Lines Matching refs:DELETE
1884 ** or [DELETE] statement are counted. Auxiliary changes caused by
1893 ** caused by an INSERT, DELETE, or UPDATE statement. Rows that
1910 ** most recent INSERT, UPDATE, or DELETE statement within the same
1914 ** number of changes in the most recent INSERT, UPDATE, or DELETE
1917 ** changes in the most recently completed INSERT, UPDATE, or DELETE
1935 ** [UPDATE] or [DELETE] statements since the [database connection] was opened.
1976 ** ^If the interrupted SQL operation is an INSERT, UPDATE, or DELETE
2451 ** [SQLITE_IGNORE] then the [DELETE] operation proceeds but the
4962 ** [UPDATE], [DELETE], or by [ON CONFLICT] side-effects
8403 /* DELETE, or UPDATE and return */
8806 u8 aAction[2]; /* ON DELETE and ON UPDATE actions, respectively */
8832 ** key is set to NULL. CASCADE means that a DELETE or UPDATE of the
9275 ** is modified by an INSERT, DELETE, or UPDATE statement. In standard SQL,
9392 #define WHERE_ONEPASS_DESIRED 0x0004 /* Want to do one-pass UPDATE/DELETE */
9409 u8 okOnePass; /* Ok to use one-pass algorithm for UPDATE or DELETE */
9425 ** to the table being operated on by INSERT, UPDATE, or DELETE. The
9563 ** trigger that may be fired while parsing an INSERT, UPDATE or DELETE
9761 * The "op" member indicates whether this is a "DELETE", "INSERT", "UPDATE" or
9778 * pWhere -> The WHERE clause of the DELETE statement if one is specified.
9795 Token target; /* Target table for DELETE, UPDATE, INSERT */
9796 Expr *pWhere; /* The WHERE clause for DELETE or UPDATE steps */
21008 OSTRACE2( "DELETE \"%s\"\n", zFilename );
28608 OSTRACE2("DELETE \"%s\"\n", zFilename);
32465 ** journalMode==DELETE
32470 ** DELETE and the pager is in exclusive mode, the method described under
35622 ** DELETE operations.
42973 ** (to 2 or 3) gives a modest improvement in SELECT and DELETE performance
49284 /* If this was an INSERT, UPDATE or DELETE and no statement transaction
57790 ** The xUpdate method will do a DELETE or an INSERT or both.
59500 ** clause processing on UPDATE and DELETE statements.
64852 "DELETE FROM %Q.%s WHERE tbl=%Q", pDb->zName, zTab, zWhere
66436 ** INSERT, UPDATE, and DELETE operations against SQLITE_MASTER. Use
68296 "DELETE FROM %s.sqlite_sequence WHERE name=%Q",
68310 "DELETE FROM %Q.%s WHERE tbl_name=%Q and type!='trigger'",
68316 "DELETE FROM %Q.sqlite_stat1 WHERE tbl=%Q", pDb->zName, pTab->zName
68347 ** in the ON DELETE, ON UPDATE and ON INSERT clauses.
68440 pFKey->aAction[0] = (u8)(flags & 0xff); /* ON DELETE action */
69132 "DELETE FROM %Q.%s WHERE name=%Q",
69138 "DELETE FROM %Q.sqlite_stat1 WHERE idx=%Q",
70383 ** in order to generate code for DELETE FROM statements.
70485 ** and LIMIT/OFFSET portion of DELETE and UPDATE statements.
70487 ** DELETE FROM table_wxyz WHERE a<5 ORDER BY a LIMIT 1;
70498 char *zStmtType /* Either DELETE or UPDATE. For error messages. */
70525 ** term for the DELETE or UPDATE statement. For example:
70526 ** DELETE FROM table_a WHERE col1=1 ORDER BY col2 LIMIT 1 OFFSET 1
70528 ** DELETE FROM table_a WHERE rowid IN (
70538 /* duplicate the FROM clause as it is needed by both the DELETE/UPDATE tree
70551 /* now generate the new WHERE rowid IN clause for the DELETE/UDPATE */
70577 ** Generate code for a DELETE FROM statement.
70579 ** DELETE FROM table_wxyz WHERE a<5 AND b NOT NULL;
70707 /* Special case: A DELETE without a WHERE clause deletes everything.
70856 ** not attempt to delete it or fire any DELETE triggers. */
70886 /* Invoke BEFORE DELETE trigger programs. */
70904 ** a view (in which case the only effect of the DELETE statement is to
70919 /* Invoke AFTER DELETE trigger programs. */
72592 ** DELETE operations:
72635 ** Before coding an UPDATE or DELETE row operation, the code-generator
72641 ** coding an INSERT operation. The functions used by the UPDATE/DELETE
72652 ** sqlite3FkActions() - Code triggers for ON UPDATE/ON DELETE actions.
72837 ** DELETE immediate Decrement the "immediate constraint counter".
72841 ** DELETE deferred Decrement the "deferred constraint counter".
72974 ** DELETE immediate Increment the "immediate constraint counter".
72975 ** Or, if the ON (UPDATE|DELETE) action is RESTRICT,
72980 ** DELETE deferred Increment the "deferred constraint counter".
72981 ** Or, if the ON (UPDATE|DELETE) action is RESTRICT,
73053 ** is taking place as part of a DELETE operation (operation D.2), omit the
73149 ** then the equivalent of "DELETE FROM <tbl>" is executed before dropping
73151 ** DELETE, but foreign key actions are not.
73164 ** the entire DELETE if there are no outstanding deferred constraints
73179 /* If the DELETE has generated immediate foreign key constraint
73199 ** For a DELETE operation, parameter regOld is passed the index of the
73211 ** described for DELETE. Then again after the original record is deleted
73386 ** row contained in table pTab. If the operation is a DELETE, then
73406 /* A DELETE operation. Foreign key processing is required if the
73445 ** This function is called when an UPDATE or DELETE operation is being
73449 ** DELETE, pChanges is passed a NULL pointer.
73452 ** equivalent to the ON UPDATE or ON DELETE action specified by pFKey.
73461 ** CREATE TABLE c(ck REFERENCES p ON DELETE CASCADE);
73465 ** CREATE TRIGGER ... DELETE ON p BEGIN
73466 ** DELETE FROM c WHERE ck = old.pk;
73477 ExprList *pChanges /* Change-list for UPDATE, NULL for DELETE */
73482 int iAction = (pChanges!=0); /* 1 for UPDATE, 0 for DELETE */
73665 ExprList *pChanges, /* Change-list for UPDATE, NULL for DELETE */
74983 /* If there are DELETE triggers on this table and the
83903 ** Construct a trigger step that implements a DELETE statement and return
83905 ** sees a DELETE statement inside the body of a CREATE TRIGGER.
84309 (pTrigger->op==TK_DELETE ? "DELETE" : ""),
84434 ** on table pTab. The operation to code triggers for (INSERT, UPDATE or DELETE)
84458 ** For ON DELETE triggers, the registers containing the NEW.* values will
84514 ** old.* record into memory when executing an UPDATE or DELETE command.
85441 "SELECT 'DELETE FROM vacuum_db.' || quote(name) || ';' "
90051 ** is called from an UPDATE or DELETE statement, then ppOrderBy is NULL.
90338 /* If the caller is an UPDATE or DELETE statement that is requesting
91552 "ON", "INSERT", "DELETE", "UPDATE",
91673 /* 76 */ "refarg ::= ON DELETE refact",
91764 /* 167 */ "cmd ::= DELETE FROM fullname indexed_opt where_opt",
91861 /* 264 */ "nmnum ::= DELETE",
91874 /* 277 */ "trigger_event ::= DELETE|INSERT",
91891 /* 294 */ "trigger_cmd ::= DELETE FROM trnm tridxby where_opt",
92820 case 264: /* nmnum ::= DELETE */ yytestcase(yyruleno==264);
92900 case 76: /* refarg ::= ON DELETE refact */
93164 case 167: /* cmd ::= DELETE FROM fullname indexed_opt where_opt */
93582 case 277: /* trigger_event ::= DELETE|INSERT */
93616 "qualified table names are not allowed on INSERT, UPDATE, and DELETE "
93623 "the INDEXED BY clause is not allowed on UPDATE or DELETE statements "
93630 "the NOT INDEXED clause is not allowed on UPDATE or DELETE statements "
93643 case 294: /* trigger_cmd ::= DELETE FROM trnm tridxby where_opt */
94302 testcase( i==63 ); /* DELETE */
103740 /* 0 */ "DELETE FROM %Q.'%q_content' WHERE rowid = ?",
103742 /* 2 */ "DELETE FROM %Q.'%q_content'",
103743 /* 3 */ "DELETE FROM %Q.'%q_segments'",
103744 /* 4 */ "DELETE FROM %Q.'%q_segdir'",
103760 /* 14 */ "DELETE FROM %Q.'%q_segdir' WHERE level = ?",
103761 /* 15 */ "DELETE FROM %Q.'%q_segments' WHERE blockid BETWEEN ? AND ?",
105829 int isRemove = 0; /* True for an UPDATE or DELETE */
105830 sqlite3_int64 iRemove = 0; /* Rowid removed by UPDATE or DELETE */
105833 /* If this is a DELETE or UPDATE operation, remove the old record. */
109802 "DELETE FROM '%q'.'%q_node' WHERE nodeno = :1",
109807 "DELETE FROM '%q'.'%q_rowid' WHERE rowid = :1",
109812 "DELETE FROM '%q'.'%q_parent' WHERE nodeno = :1"