AnswerBun.com

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 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP