From: Daniel Kiss [mailto:[EMAIL PROTECTED] > Hi all, > > How should I set the parameters of the LOAD DATA LOCAL INFILE > command for a comma separated text file like this: > > "Text field",.4,123 > "Text field with "" included quote",,45 > "Text field with "","" a comma between quotes",1.2,44
I believe it's... LOAD DATA LOCAL INFILE '/path/to/file' INTO TABLE tablename FIELDS TERMINATED BY ',' OPTONALLY ENCLOSED BY '"'; -- Mike Johnson Web Developer/Systems Asst. Smarter Living, Inc. phone (617) 497-2500 x226 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
