The UPDATE
statement modifies existing records in a table. You specify which table, what to update, and which rows to target.
UPDATE
— Specifies the table to modify.SET
— Lists the columns to update with their new values.WHERE
— Filters which records to update (leave it out and it'll hit all rows — danger zone ⚠️).' '
.;
.WHERE
clause, or you might accidentally update your whole table.