Re: Comment importer des NULL dans mysql ?
J'ai finalement trouvé une solution en mettant \N (2 caractères au lieu de 4 pour NULL)
mysqlimport --lines-terminated-by="\r\n" --fields-terminated-by="," --delete -L -ulogin -ppassword -v -hserveur base nomtable.csv
avec un fichier csv de la forme :
1,\N,416416
452452,4456,\N
Subject
Views
Written By
Posted
4721
September 15, 2010 01:21AM
Re: Comment importer des NULL dans mysql ?
2159
September 15, 2010 03:16AM
2301
September 16, 2010 09:18AM
2533
November 04, 2010 02:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.