SQL UPDATE Statement Builder

How to use

1. 1Pick a mode: Single row / filter for one set of values targeted by a WHERE clause, or Bulk by key to update many rows to different values from a pasted table.
2. 2Choose the SQL dialect, set the table name (and optional schema), and in single mode pick the parameter style your driver uses or inline literals.
3. 3In single mode, add one row per column to change, choose each value's type, enter the value, and type the WHERE clause that selects the rows to update.
4. 4In bulk mode, paste a header row plus one row per record, then name the key column; every other column becomes a CASE expression keyed on that column.
5. 5Read the generated UPDATE statement, copy it with the copy button, and copy the bound parameter values too when you are using a parameterized style.

About this tool

SQL UPDATE Statement Builder writes the UPDATE statement for you so a routine data fix does not turn into a query that changes every row by accident. It has two modes. Single row / filter mode builds the everyday shape, UPDATE table SET column = value, column = value WHERE condition: add one row per column you want to change, choose each value's type (text, number, boolean, date and time, NULL, or a raw expression such as login_count + 1), and type a WHERE clause to target the rows. Bulk by key mode solves the harder problem of setting many rows to different values at once. Paste a small table (a header row, then one row per record, comma or tab separated), name the key column that identifies each row, and the builder turns every other column into a CASE expression so a single statement updates each row to its own value, guarded by a WHERE key IN (...) list so rows you did not list are left untouched. Six dialects are supported: MySQL and MariaDB, PostgreSQL, SQLite, SQL Server, Oracle, and BigQuery. Each one quotes identifiers its own way (backticks, double quotes, or square brackets) and formats boolean and date literals correctly, including Oracle TO_DATE wrapping and the DATE and TIMESTAMP prefixes Postgres and BigQuery expect, so the same form produces valid SQL on every engine. In single mode you choose between parameterized output (positional ?, numbered $1, named :p1, or named @p1) and inline literals; with parameters, a separate panel lists the bound values in order so they paste straight into your driver call, which keeps user input out of the SQL text and is the safe way to run an UPDATE. String values are escaped by doubling single quotes, numbers and booleans are typed per dialect, and a raw expression value is emitted verbatim so you can reference other columns or call functions. The tool also warns about the most common UPDATE mistakes: a missing table name, no SET assignments, and above all a missing WHERE clause, which would rewrite the whole table. Everything runs locally in your browser, so the table names, column names, and values you enter are never uploaded, logged, or stored.

Free to use. Works in your browser. No signup, no login.