Lines Matching refs:INSERT
1475 ** successful [INSERT] into the database from the [database connection]
1476 ** in the first argument. ^If no successful [INSERT]s
1479 ** ^(If an [INSERT] occurs within a trigger, then the [rowid] of the inserted
1484 ** ^An [INSERT] that fails due to a constraint violation is not a
1485 ** successful [INSERT] and does not change the value returned by this
1486 ** routine. ^Thus INSERT OR FAIL, INSERT OR IGNORE, INSERT OR ROLLBACK,
1487 ** and INSERT OR ABORT make no changes to the return value of this
1488 ** routine when their insertion fails. ^(When INSERT OR REPLACE
1490 ** INSERT continues to completion after deleting rows that caused
1491 ** the constraint problem so INSERT OR REPLACE will always change
1494 ** ^For the purposes of this routine, an [INSERT] is considered to
1500 ** If a separate thread performs a new [INSERT] on the same
1515 ** ^(Only changes that are directly specified by the [INSERT], [UPDATE],
1525 ** caused by an INSERT, DELETE, or UPDATE statement. Rows that
1542 ** most recent INSERT, UPDATE, or DELETE statement within the same
1546 ** number of changes in the most recent INSERT, UPDATE, or DELETE
1549 ** changes in the most recently completed INSERT, UPDATE, or DELETE
1566 ** ^This function returns the number of row changes caused by [INSERT],
1608 ** ^If the interrupted SQL operation is an INSERT, UPDATE, or DELETE
1884 ** char *zSQL = sqlite3_mprintf("INSERT INTO table VALUES('%q')", zText);
1893 ** INSERT INTO table1 VALUES('It''s a happy day!')
1900 ** INSERT INTO table1 VALUES('It's a happy day!');
1912 ** char *zSQL = sqlite3_mprintf("INSERT INTO table VALUES(%Q)", zText);
2655 ** X is an [INSERT], [UPDATE], [DELETE], CREATE, DROP, [ANALYZE],