a apiary.
← All tools

SQL / BROWSER UTILITY

SQL INSERT Builder

Generate INSERT statements from rows of text, numbers and NULL values for your SQL dialect.

Processed locally in your browser. Your SQL is not uploaded or executed.

Enter names, not expressions. Use dialect quotes around names with spaces. Ordinary Oracle names use uppercase; ordinary PostgreSQL names use lowercase. Text values are escaped, never executed.

Columns
Rows

Apiary never executes SQL. Review the statement against your database before using it. Oracle treats empty text as NULL. SQLite uses type affinities and does not enforce declared text lengths or decimal precision.

Good to know

Choose explicit Text, Number or NULL values. Oracle uses INSERT ALL for multiple rows; other dialects use multi-row VALUES. Review generated statements against your database before use.

Example: Add Notebook and Pencil as two product_name rows.