CODEWITHSUNDEEP
sqlpostgresqlsql-update
Rafalsonn
Rafalsonn

Reputation: 440

postgresql: Update more than one record

I'm writing an app which updates more than one record in postgresql database.
I'm trying something like this:

UPDATE myDatabase SET internalNumber=30 WHERE id=10,12,13;

or like this: 

UPDATE myDatabase SET internalNumber=30 WHERE id=10,id=12,id=13;

But nothing I've tried works.
What can I do?
Greetings, Rafał

Upvotes: 0

Views: 48

Answers (1)

Jiri Tousek
Jiri Tousek

Reputation: 12440

UPDATE myDatabase SET internalNumber=30 WHERE id IN (10, 12, 13)

Upvotes: 2

Related Questions