Ben Pearce
Ben Pearce

Reputation: 7094

What is wrong with this sqlite Update statement

Can anyone tell me what's wrong with the update statement below

"UPDATE users EVENTS  (dateHash) = ('1') WHERE (id = 5)"

The field 'id' is of type INTEGER PRIMARY KEY AUTOINCREMENT and 'dateHash' is of type INTEGER.

edited statement

"UPDATE EVENTS  (dateHash) = ('1') WHERE (id = 5)"

Upvotes: 0

Views: 41

Answers (1)

Jade
Jade

Reputation: 2992

You forgot SET

UPDATE "EVENTS" SET dateHash = 1 WHERE id = 5

Upvotes: 1

Related Questions