search

Arp-G / csv2sql

A blazing fast fully-automated CSV to database importer
MIT License
54 stars 4 forks source link

Handle blank or invalid cloumn names #23

Open Arpan-Kreeti opened 2 years ago

Arpan-Kreeti commented 2 years ago

If the column name has trailing space or is an empty string then handle that and also log it

Currently, it gives an error like

MyXQL.Error{connection_id: 78, message: "(1166) (ER_WRONG_COLUMN_NAME) Incorrect column name 'Sub-Skill Areas '", mysql: %{code: 1166, name: :ER_WRONG_COLUMN_NAME},