UPDATE TOP in Sqlite
2 answers
SQLite supports TOP N queries, but uses a LIMIT clause to accomplish this. Anyway, this is only for SELECT statements, not for UPDATE. If you only want to update one row, you need to filter the UPDATE using the WHERE clause.
Edit:
I'm fixing it, the UPDATE statement appears to support the LIMIT clause .
0
source to share