Re: 64 /64 Server workbench/ Data Load from Excel sheet

[Info question]

I have 64/64 , Not able to import data from Excel


19:16:00 Restoring C:\Users\\Documents\ICGE contracts\contract_data_load.csv
Running: mysql.exe --defaults-file="c:\users\\appdata\local\temp\1\tmpelrkqc.cnf" --protocol=tcp --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments --database=test < "C:\\Users\\vDocuments\\ICGE contracts\\contract_data_load.csv"
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'contract_contr_id,contract_contr_eff_dt,contract_contr_duration,contract_contr_n' at line 1

Operation failed with exitcode 1
19:16:00 Import of C:\Users\\Documents\ICGE contracts\contract_data_load.csv has finished with 1 errors

MySQL Query

MySQL Query