Mysql Workbench import CSV 0 record imported

Question

I'm using MySql workbench to import CSV files all the time. And it's always working perfectly besides the only I issue Im having now is, there's a CSV file would not get imported. No error occured during the import process. But when import finished, it shows 0 record imported. I've checked the table columns so I'm sure the data type match the CSV file. What did I miss?

Zhenyu · Answer

OK. It was because I datatime format didn't match that in CSV file. It weird because I noticed it at first place, then I unmarked the date column to imported, it seems even you unmark the column, the mysql workbench still take that column into consideration.

Answered by Zhenyu on December 19, 2020

Mysql Workbench import CSV 0 record imported

One Answer

Add your own answers!

Ask a Question