M E Fieu kirjoitti viestissään (lähetysaika keskiviikko, 16. maaliskuuta 2005 09:26): > Hi.. I create a data.csv file using excel file and > convert to CSV as following (...) > but when i tried to load the CSV file into the table > department, the name and job column still shown as > NULL? Why?? Any soiution? > > mysql>load data local infile '/root/data.csv' into > table department; LOAD DATA expects by default that fields are separated by tabs, not commas. You must specify that a comma is used as a delimiter: LOAD DATA LOCAL INFILE '/root/data.csv' INTO TABLE department FIELDS TERMINATED BY ','; http://dev.mysql.com/doc/mysql/en/load-data.html -- Markku Kolkka markku.kolkka@xxxxxx
