ANSI Standard Syntax for UPDATE

Change existing rows with UPDATE ... SET, and always limit it with a WHERE clause you've checked with a SELECT first.

Updated

Cheat sheet: ANSI Standard Syntax for UPDATE
Category
SQL
Level
Apprentice
Tags
mysql, sql