SQL UPDATE Builder
Build an UPDATE statement from one `column = value` per line, with identifiers checked and string values quoted or refused.
What the SQL UPDATE Builder does
Identifiers are checked against SQL's plain identifier shape, so a table or column with a space or a dash is refused rather than emitted unquoted. A quoted string keeps its quotes, and a doubled quote inside it stays escaped.
The WHERE clause is appended verbatim after a semicolon check, because it is a predicate this page cannot parse without knowing your schema.
Values are not parameterised: the statement is text with literals inlined. Never paste a statement built from untrusted input into a database — use parameters instead. The WHERE clause is not parsed, so a typo there is yours.
How to use it
Type the assignments into the Assignments box, one column = value per line, and set Table and WHERE clause.
Press Run and read the UPDATE statement below: the SET list keeps your line order.
Check a text value in the UPDATE statement — it must be in single quotes; an unquoted word is refused with the column named.
Worked example
Input:
name = 1
title = 'Ada'
Output:
UPDATE users
SET name = 1,
title = 'Ada'
WHERE id = 5;
Why it runs in your browser
The result is produced on this page with JavaScript, so it works offline after the page loads and nothing you enter is sent anywhere.
An UPDATE statement whose SET list comes from the lines you paste: one `column = value` per line, one line of output per assignment.
A value that is not a number, a boolean, null or a single-quoted string is refused by column name, because an unquoted word is a column reference you probably did not mean.
What it does, and what it does not
Identifiers are checked against SQL's plain identifier shape, so a table or column with a space or a dash is refused rather than emitted unquoted. A quoted string keeps its quotes, and a doubled quote inside it stays escaped.
The WHERE clause is appended verbatim after a semicolon check, because it is a predicate this page cannot parse without knowing your schema.
Values are not parameterised: the statement is text with literals inlined. Never paste a statement built from untrusted input into a database — use parameters instead. The WHERE clause is not parsed, so a typo there is yours.
How to use SQL UPDATE Builder
Type the assignments into the Assignments box, one `column = value` per line, and set Table and WHERE clause.
Press Run and read the UPDATE statement below: the SET list keeps your line order.
Check a text value in the UPDATE statement — it must be in single quotes; an unquoted word is refused with the column named.
What to Expect
Best for
- Drafting a targeted update for review
- Checking which columns a statement touches
Not ideal for
- Production use with untrusted values, which needs parameters
- A multi-table update, which this page does not model
What this tool keeps
- Your assignment order
- A quoted string exactly as you wrote it
What may need cleanup
- Replace literals with parameters before running it
- Review the WHERE clause by hand
Common errors
- The page refuses it: value for name must be a number, true, false, null or a single-quoted string
Example use cases
- Writing a one-off data fix for review
- Documenting which columns a change touches
Sample input
Assignments: name = 1 …
Sample output
UPDATE statement: UPDATE users …
Who this is for
- Developers preparing a data fix
- DBAs reviewing an update before it runs
Frequently asked questions
Why must text be quoted?
An unquoted word is a column or a keyword, not a string. Quoting it makes the statement mean what you typed, and the page refuses the unquoted form by column name.
Should the WHERE clause be left empty?
Only if you mean to update every row. The page omits the predicate when the box is empty, which is exactly what the statement then does.
Does it parameterise the values?
No, and it says so: literals are inlined, which is fine for review and not safe for untrusted input. Use your driver's parameters for that.
Build custom tools for your store
Join the SDK program to create useful ecommerce utilities for your store.