lundi 5 janvier 2015

How can I insert null for empty numerical value?


I have some comma separated files and I would like to import into MySQL. However there are empty strings



20121128020001,2012-11-28 02:00:01.000,,,,,,,3.80,,,,,


I tried to use seed



sed -i 's/,,/,\\N,/g' Test.CSV


Where I get the following result:



0121128020001,2012-11-28 02:00:01.000,\N,,\N,,\N,,3.80,\N,,\N,,


I am wondering if it is possible to insert NULL instead of zeros in the MySQL database using mysqlimport command. I have 43 csv file with different columns.





Aucun commentaire:

Enregistrer un commentaire