Is it possible to update multiple records in a single update statement?

If so, can I give them individual values?

Yes, you can update multiple columns with an UPDATE statement.
The basic syntax is:

UPDATE table
SET column1 = value1,
    column2 = value2,
[WHERE conditions applies to the rows you want to update];

Do you have an example of your work?


I wasn’t working on anything, I was just wondering for future use. Thank you for answering.

1 Like