Re: help with load from file

[trogers]

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: trogers@stripped [mailto:trogers@stripped]
> 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","","",""