Steve Grosz <[EMAIL PROTECTED]> writes:
>Can anyone tell me a good way to import individual column data into a
>table? Is there a tool to assist with this?
If your data is a .csv file [a.csv] similar to:
1,"Steve","Grosz"
2,"Brad","Eacker"
Consistent with the output from Excel. You could use
LOAD DATA LOCAL INFILE 'a.csv' INTO TABLE Users
FIELDS TERMINATED BY ','
(id,firstName,lastName);
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
