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;
- christian.dinh2476 total contributions
- Anonymous contributorAnonymous contributor3071 total contributions