CSV

Converts CSV data to SQL DDL and insert statements

Rules

  • You can specify a column as primary key in Options
  • Primary key type is mapped to integer if value is numeric
  • Numeric values are mapped as
    • integer if all the rows for that column contain only integer numbers
    • decimal (15, 5) if any of the rows contains a decimal number
    • decimal (25, 5) if any of the rows contains a decimal number and its value is greater than 2^31 - 1
  • Text values are mapped as
    • varchar(64) if all the rows for that column contain text 64 characters or less
    • text if any of the rows for that column contain text 64 or more characters