question

sam09 avatar image
sam09 asked

error while importing csv file

`DOJ` date DEFAULT NULL, Hello, i want to import data to mysql table,but im getting error mysql default null date constrains have yyyy/mm/dd formate but while importing csv file to it wont show proper value. it not possible to change yyyy/mm/dd formate to csv file formate ...please advice![alt text][1] [1]: /storage/temp/3179-22222222222222.png
mysqlcsvimport
22222222222222.png (10.1 KiB)
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sam09 avatar image sam09 commented ·
solved thanks for no reply
1 Like 1 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
It's possible that no one here has a good answer for you. This site is dedicated to Microsoft SQL Server and Oracle. There aren't that many people who know MySQL, a completely different product. I'll see if I can get someone over here that knows that.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.