UPDATE

noun

say it: “up-DAYT” /ʌpˈdeɪt/

The SQL statement that changes values in rows that already exist.

What does UPDATE do in a relational database?

UPDATE — A statement that changes values in existing rows.

UPDATE customer
SET status = 'inactive'
WHERE customer_id = 1;

In a sentence

  • “An UPDATE raised the price of Chai to $19.”

Level: Apprentice · More SQL terms at this level

Updated