Skip to main content

UPDATE changes the values of the specified columns in all rows that satisfy the condition. Only the columns to be modified need be mentioned in the SET clause; columns not explicitly modified retain their previous values.


An SQL UPDATE statement changes the data of one or more records in a table. Either all the rows can be updated, or a subset may be chosen using a condition.

UPDATE (computing/software)

Piece of software that includes fixing security vulnerabilities and other bugs, and/or improving the usability or performance.