About sql insert generator
Write a safe INSERT statement from column = value lines, with quoting handled for you.
Quoting
Text values go in single quotes, and a single quote inside text is doubled. Numbers and NULL are not quoted.
Back up before you run SQL
Review generated statements, run them on a test database first and keep a backup. UPDATE and DELETE without a WHERE clause affect every row. Values pasted into SQL by hand can also open the door to SQL injection, so use parameterised queries in application code.
A worked example
The lines name = Asha, age = 30 and city = Pune with the table users produce INSERT INTO users (name, age, city) VALUES ('Asha', 30, 'Pune'); Text is quoted and an apostrophe inside a value is doubled, as in 'D''Souza'. Use parameterised queries in code instead of building SQL from user input.
