Published Jun 4, 2021Updated Aug 18, 2022
Contribute to Docs
UPDATE command edits one or more rows in a table.
UPDATE table_nameSET some_column = some_valueWHERE some_column = some_value;
SET clause is included to indicate that the column to edit as well as a
WHERE clause for specifying the record(s).
The given query will update the row for a specific customer ID in the
UPDATE customersSET name = 'Code Ninja', city = 'Brooklyn'WHERE customer_id = 123;
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
Learn SQL on Codecademy
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses