I'm trying to import a data set from a CSV file. This works correctly except that blank values don't get inserted as NULL. I have to manually set NULL (Shift+Ctrl+N).
Do I need to set a special character in the CSV or am I missing something?
How do I import NULL
Thanks anse - this is exactly what I needed:
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
Please login to leave a reply, or register at first.