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