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]
