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