Конвертер CSV в SQL
Преобразование данных CSV в SQL-операторы. Генерация операторов CREATE TABLE и INSERT с автоматическим определением типов.
Type Detection
- Column types are automatically inferred from data values
- Dates (YYYY-MM-DD) and timestamps are detected
- Boolean values: true/false, 1/0, yes/no
- Empty values and "NULL" are converted to NULL
CSV to SQL Conversion - Технические детали
Converting CSV to SQL is useful for importing spreadsheet data into databases. This tool automatically detects column types (integer, decimal, boolean, date, string) and generates properly escaped SQL statements.
Альтернатива командной строки
# Import CSV directly in PostgreSQL\n\\copy my_table FROM 'data.csv' WITH CSV HEADER;\n\n# MySQL\nLOAD DATA INFILE 'data.csv' INTO TABLE my_table\nFIELDS TERMINATED BY ',';