Lines Matching refs:DELETE
1887 ** or [DELETE] statement are counted. Auxiliary changes caused by
1896 ** caused by an INSERT, DELETE, or UPDATE statement. Rows that
1913 ** most recent INSERT, UPDATE, or DELETE statement within the same
1917 ** number of changes in the most recent INSERT, UPDATE, or DELETE
1920 ** changes in the most recently completed INSERT, UPDATE, or DELETE
1938 ** [UPDATE] or [DELETE] statements since the [database connection] was opened.
1979 ** ^If the interrupted SQL operation is an INSERT, UPDATE, or DELETE
2454 ** [SQLITE_IGNORE] then the [DELETE] operation proceeds but the
4965 ** [UPDATE], [DELETE], or by [ON CONFLICT] side-effects
8406 /* DELETE, or UPDATE and return */
8809 u8 aAction[2]; /* ON DELETE and ON UPDATE actions, respectively */
8835 ** key is set to NULL. CASCADE means that a DELETE or UPDATE of the
9278 ** is modified by an INSERT, DELETE, or UPDATE statement. In standard SQL,
9395 #define WHERE_ONEPASS_DESIRED 0x0004 /* Want to do one-pass UPDATE/DELETE */
9412 u8 okOnePass; /* Ok to use one-pass algorithm for UPDATE or DELETE */
9428 ** to the table being operated on by INSERT, UPDATE, or DELETE. The
9566 ** trigger that may be fired while parsing an INSERT, UPDATE or DELETE
9764 * The "op" member indicates whether this is a "DELETE", "INSERT", "UPDATE" or
9781 * pWhere -> The WHERE clause of the DELETE statement if one is specified.
9798 Token target; /* Target table for DELETE, UPDATE, INSERT */
9799 Expr *pWhere; /* The WHERE clause for DELETE or UPDATE steps */
21011 OSTRACE2( "DELETE \"%s\"\n", zFilename );
28611 OSTRACE2("DELETE \"%s\"\n", zFilename);
32468 ** journalMode==DELETE
32473 ** DELETE and the pager is in exclusive mode, the method described under
35625 ** DELETE operations.
42976 ** (to 2 or 3) gives a modest improvement in SELECT and DELETE performance
49287 /* If this was an INSERT, UPDATE or DELETE and no statement transaction
57793 ** The xUpdate method will do a DELETE or an INSERT or both.
59503 ** clause processing on UPDATE and DELETE statements.
64855 "DELETE FROM %Q.%s WHERE tbl=%Q", pDb->zName, zTab, zWhere
66439 ** INSERT, UPDATE, and DELETE operations against SQLITE_MASTER. Use
68299 "DELETE FROM %s.sqlite_sequence WHERE name=%Q",
68313 "DELETE FROM %Q.%s WHERE tbl_name=%Q and type!='trigger'",
68319 "DELETE FROM %Q.sqlite_stat1 WHERE tbl=%Q", pDb->zName, pTab->zName
68350 ** in the ON DELETE, ON UPDATE and ON INSERT clauses.
68443 pFKey->aAction[0] = (u8)(flags & 0xff); /* ON DELETE action */
69135 "DELETE FROM %Q.%s WHERE name=%Q",
69141 "DELETE FROM %Q.sqlite_stat1 WHERE idx=%Q",
70386 ** in order to generate code for DELETE FROM statements.
70488 ** and LIMIT/OFFSET portion of DELETE and UPDATE statements.
70490 ** DELETE FROM table_wxyz WHERE a<5 ORDER BY a LIMIT 1;
70501 char *zStmtType /* Either DELETE or UPDATE. For error messages. */
70528 ** term for the DELETE or UPDATE statement. For example:
70529 ** DELETE FROM table_a WHERE col1=1 ORDER BY col2 LIMIT 1 OFFSET 1
70531 ** DELETE FROM table_a WHERE rowid IN (
70541 /* duplicate the FROM clause as it is needed by both the DELETE/UPDATE tree
70554 /* now generate the new WHERE rowid IN clause for the DELETE/UDPATE */
70580 ** Generate code for a DELETE FROM statement.
70582 ** DELETE FROM table_wxyz WHERE a<5 AND b NOT NULL;
70710 /* Special case: A DELETE without a WHERE clause deletes everything.
70859 ** not attempt to delete it or fire any DELETE triggers. */
70889 /* Invoke BEFORE DELETE trigger programs. */
70907 ** a view (in which case the only effect of the DELETE statement is to
70922 /* Invoke AFTER DELETE trigger programs. */
72595 ** DELETE operations:
72638 ** Before coding an UPDATE or DELETE row operation, the code-generator
72644 ** coding an INSERT operation. The functions used by the UPDATE/DELETE
72655 ** sqlite3FkActions() - Code triggers for ON UPDATE/ON DELETE actions.
72840 ** DELETE immediate Decrement the "immediate constraint counter".
72844 ** DELETE deferred Decrement the "deferred constraint counter".
72977 ** DELETE immediate Increment the "immediate constraint counter".
72978 ** Or, if the ON (UPDATE|DELETE) action is RESTRICT,
72983 ** DELETE deferred Increment the "deferred constraint counter".
72984 ** Or, if the ON (UPDATE|DELETE) action is RESTRICT,
73056 ** is taking place as part of a DELETE operation (operation D.2), omit the
73152 ** then the equivalent of "DELETE FROM <tbl>" is executed before dropping
73154 ** DELETE, but foreign key actions are not.
73167 ** the entire DELETE if there are no outstanding deferred constraints
73182 /* If the DELETE has generated immediate foreign key constraint
73202 ** For a DELETE operation, parameter regOld is passed the index of the
73214 ** described for DELETE. Then again after the original record is deleted
73389 ** row contained in table pTab. If the operation is a DELETE, then
73409 /* A DELETE operation. Foreign key processing is required if the
73448 ** This function is called when an UPDATE or DELETE operation is being
73452 ** DELETE, pChanges is passed a NULL pointer.
73455 ** equivalent to the ON UPDATE or ON DELETE action specified by pFKey.
73464 ** CREATE TABLE c(ck REFERENCES p ON DELETE CASCADE);
73468 ** CREATE TRIGGER ... DELETE ON p BEGIN
73469 ** DELETE FROM c WHERE ck = old.pk;
73480 ExprList *pChanges /* Change-list for UPDATE, NULL for DELETE */
73485 int iAction = (pChanges!=0); /* 1 for UPDATE, 0 for DELETE */
73668 ExprList *pChanges, /* Change-list for UPDATE, NULL for DELETE */
74986 /* If there are DELETE triggers on this table and the
83906 ** Construct a trigger step that implements a DELETE statement and return
83908 ** sees a DELETE statement inside the body of a CREATE TRIGGER.
84312 (pTrigger->op==TK_DELETE ? "DELETE" : ""),
84437 ** on table pTab. The operation to code triggers for (INSERT, UPDATE or DELETE)
84461 ** For ON DELETE triggers, the registers containing the NEW.* values will
84517 ** old.* record into memory when executing an UPDATE or DELETE command.
85444 "SELECT 'DELETE FROM vacuum_db.' || quote(name) || ';' "
90054 ** is called from an UPDATE or DELETE statement, then ppOrderBy is NULL.
90341 /* If the caller is an UPDATE or DELETE statement that is requesting
91555 "ON", "INSERT", "DELETE", "UPDATE",
91676 /* 76 */ "refarg ::= ON DELETE refact",
91767 /* 167 */ "cmd ::= DELETE FROM fullname indexed_opt where_opt",
91864 /* 264 */ "nmnum ::= DELETE",
91877 /* 277 */ "trigger_event ::= DELETE|INSERT",
91894 /* 294 */ "trigger_cmd ::= DELETE FROM trnm tridxby where_opt",
92823 case 264: /* nmnum ::= DELETE */ yytestcase(yyruleno==264);
92903 case 76: /* refarg ::= ON DELETE refact */
93167 case 167: /* cmd ::= DELETE FROM fullname indexed_opt where_opt */
93585 case 277: /* trigger_event ::= DELETE|INSERT */
93619 "qualified table names are not allowed on INSERT, UPDATE, and DELETE "
93626 "the INDEXED BY clause is not allowed on UPDATE or DELETE statements "
93633 "the NOT INDEXED clause is not allowed on UPDATE or DELETE statements "
93646 case 294: /* trigger_cmd ::= DELETE FROM trnm tridxby where_opt */
94305 testcase( i==63 ); /* DELETE */
103743 /* 0 */ "DELETE FROM %Q.'%q_content' WHERE rowid = ?",
103745 /* 2 */ "DELETE FROM %Q.'%q_content'",
103746 /* 3 */ "DELETE FROM %Q.'%q_segments'",
103747 /* 4 */ "DELETE FROM %Q.'%q_segdir'",
103763 /* 14 */ "DELETE FROM %Q.'%q_segdir' WHERE level = ?",
103764 /* 15 */ "DELETE FROM %Q.'%q_segments' WHERE blockid BETWEEN ? AND ?",
105832 int isRemove = 0; /* True for an UPDATE or DELETE */
105833 sqlite3_int64 iRemove = 0; /* Rowid removed by UPDATE or DELETE */
105836 /* If this is a DELETE or UPDATE operation, remove the old record. */
109805 "DELETE FROM '%q'.'%q_node' WHERE nodeno = :1",
109810 "DELETE FROM '%q'.'%q_rowid' WHERE rowid = :1",
109815 "DELETE FROM '%q'.'%q_parent' WHERE nodeno = :1"