Mysql Workbench import CSV 0 record imported

Super User Asked by Zhenyu on December 19, 2020

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?

One 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

Add your own answers!

Related Questions

B85M-K Motherboard 2x8GB ram DDR3 no monitor signal

2  Asked on December 27, 2021 by hamed-mayahian


How to disable user tracking cookies

1  Asked on December 25, 2021 by ravi-kumar-rana


FTP client not working inside Docker container

2  Asked on December 25, 2021 by iskar


Inkscape: Convert fill pattern to path

1  Asked on December 25, 2021 by user281318


Error at OID for old SNMP Hardware

1  Asked on December 25, 2021 by mfb


Can Windows ACL emulate the sticky bit?

0  Asked on December 25, 2021 by user185953


Ask a Question

Get help from others!

© 2022 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP