I will try that.
Thanks.
----- Original Message -----
From: "Victor Pendleton" <[EMAIL PROTECTED]>
To: "'Haplo '" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: "'Paul '" <[EMAIL PROTECTED]>
Sent: Thursday, May 27, 2004 1:28 PM
Subject: RE: Textfile to table
> How is the data delimited? You may be able to use the LOAD DATA INFILE
> command.
>
> -----Original Message-----
> From: Haplo
> To: [EMAIL PROTECTED]
> Cc: Paul
> Sent: 5/27/04 12:23 PM
> Subject: Textfile to table
>
> Hi,
> I am trying to add this info into a table and I know there is a way to
> do it without using the insert command on every line of data.
>
> 201 200 NJ Jersey City
>
>
>
> INSERT INTO categories VALUES ('201', '200', 'NJ', 'Jersey City');
>
>
>
> there are way too many lines to do by manual inserts.
>
>
>
> Any comments would help. Thanks
>
>
>
> Paul
>
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
