I have a SQLite syntax error in DELETE statement

Question

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, &errorMsg);
if (returnCode!=SQLITE_OK) 
{
    fprintf(stderr, "Error: %s", errorMsg);
    sqlite3_free(errorMsg);
}

 Error: near "t1": syntax error

But this code works well

const char *statement = "DELETE FROM quotes WHERE id=127";
int returnCode = sqlite3_exec(database, statement, NULL, NULL, &errorMsg);

Mark Byers · Accepted Answer · 2012-07-22 15:37:04Z

5

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

answered Jul 22, 2012 at 15:37

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

I have a SQLite syntax error in DELETE statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related