WeLLLL, ok. Thank you all. This worked quite nicely and I learned something to boot!
TR
On Tuesday, May 27, 2003, at 11:00 PM, Steve Gums wrote:
The numbers should be without the quotes and the end of line character can
stay as is.
Once you have this you should be able to do something like this.
load data local infile '<path to infile>' into table <table name> fields
terminated by ',' optionally enclosed by '"';
This is what I used and it worked very well.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 27, 2003 8:31 PM To: MySQL List Subject: Re: help with load from file
I also have it prepared like this:
"1","Mac","SE30","314784","LOV","115","","","" "2","Mac","Performa6300CD","338211","LOV","109","","",""
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]