# 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.

![Cheat sheet: ANSI Standard Syntax for UPDATE](https://fsdtrainingmedia.blob.core.windows.net/public/images/2026/11/9b3b6f5180384e9aa280862e1f8f0b22.webp)

- Category: SQL
- Level: Apprentice
- Tags: mysql, sql
- Updated: November 3, 2026

Source: https://www.ask-codey.com/cheat-sheets/updating-data-ansi-standard-syntax-for-update-cheat-sheet