Skip to content Skip to sidebar Skip to footer
Home / Macos / Sqlite

I Have A Sqlite Syntax Error In Delete Statement

Post a Comment
I have a very strange sqlite syntax error. const char *statement = 'DELETE FROM quotes t1 WHERE t1.id=127'; int returnCode = sqlite3_exec(database, statement, NULL, NULL, &erro

Solution 1:

SQLite doesn't allow aliases in delete statements.

See the manual for the allowed syntax.

delete-stmt

enter image description here

qualified-table-name

enter image description here

Post a Comment for "I Have A Sqlite Syntax Error In Delete Statement"