Scroll to continue reading
CSV To SQL Converter

CSV To SQL Converter

CSV To SQL Converter

Separator

Input

Convert

Output



Instruction

This converter converts .csv files with “,” or “;” -separator to a part of SQL query next format:

(column1, column2, ..., columnk) VALUES(value1, value2, ..., valuek),(value1, value2, ..., valuek),(value1, value2, ..., valuek),...
So input data should have next format:
column1,column2,...,columnkvalue1,value2,...,valuekvalue1,value2,...,valuekvalue1,value2,...,valuek...
or:
column1;column2;...;columnkvalue1;value2;...;valuekvalue1;value2;...;valuekvalue1;value2;...;valuek...
The main advantage of this script is that it gives you ready sql query part to load it to db. It is simple:
"INSERT INTO table" + csv_to_sql(input, separator)
Also this script can convert values, which are contains “,”.
To add this feature to your project simply copy csv_to_sql function from JS block.