csv to sql insert statement
The sqlite or postgresql insert statement will be generated with the header CSV, leaving the text number.
csv to sql insert statement User manual
- Fill in the parameters or select the file according to the form, and check the unit and format first.
- Insert the test table with the customer CSV generated with a leading zero number.
- Click the processing button to view the results, you can copy or download and save.
Calculation method and processing rules
Escape the identifiers and strings separately. By default, each cell is processed as text, and the null value can be set to null.
scope of use
Up to 1999 lines; do not connect to the database, do not infer the numeric type, do not create a table, and do not apply to the default backslash escape rule of MySQL.
Will the input content be saved on the server?
This tool handles input in the browser, and does not upload files or form content. Typing practice scores are only saved in the native browser.
Why may the result be different from other tools?
Up to 1999 lines; do not connect to the database, do not infer the numeric type, do not create a table, and do not apply to the default backslash escape rule of MySQL. Please compare the input unit, rounding method, applicable rules and data version first.