A CSV to SQL conversion is useful for a small fixture or controlled import. The generated statements still need review, particularly where quoting rules and column types differ between databases.
CSV to SQL INSERT Builder produces INSERT statements as text. It never executes them or connects to your database.
Keep codes as text
For a CSV headed name,code with O'Brien,001 as a record, the apostrophe is doubled in the SQL string and the code remains quoted text. That preserves the leading zeros instead of turning the code into the number 1.
Choose a simple ASCII table name and column headers. The tool restricts identifiers rather than allowing arbitrary expressions, dotted SQL fragments or command text as a name.
An empty cell can remain an empty string or become NULL, depending on the selected rule. Those values have different meanings in a database. Choose deliberately before creating the statements.
Match the destination dialect
Standard or SQLite style quoting and a MySQL option are available. MySQL output requires NO_BACKSLASH_ESCAPES mode. Do not assume that a file prepared under that rule can safely be used with different connection settings.
The generator does not infer numeric, date or Boolean column types. Values remain quoted strings, and the database may apply its own conversion rules when you eventually import them.
Review a record containing an apostrophe and one containing a backslash. Then test the statements in a suitable isolated database before considering a real import.
For repeated application writes, parameterised queries are normally a better programming interface than constructing SQL text by hand. This tool is a preparation aid for reviewed statements, not an automatic migration system or a substitute for access controls and backups.