Re: [PHP-DB] bulk miorting rows into mysql db

[Adam Williams]

use mysqlimport, its a program that comes with MySQL.  go to www.mysql.com
and click on documentation to learn more about it.

Adam

On Fri, 13 Dec 2002, mikek wrote:

 I have a few hundred rows of data to import into a mysql db. Its currently
 tab separated.

 What's the most straight forward way (ie i dont want to enter it line by
 line) of doing a bulk import?

 I have full admin rights to my dev server. Is there a method or software app
 that people can recommend to me.

 Much appreciated.

 ---
 Mike Karthauser - email:[EMAIL PROTECTED] - phone:0117 9426653
 brightstorm - curiously online - http://www.brightstorm.co.uk





-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] bulk miorting rows into mysql db

[1LT John W. Holmes]

 I have a few hundred rows of data to import into a mysql db. Its currently
 tab separated.

 What's the most straight forward way (ie i dont want to enter it line by
 line) of doing a bulk import?

 I have full admin rights to my dev server. Is there a method or software
app
 that people can recommend to me.

If the columns match your database exactly, then you can use LOAD DATA
INFILE command.

If not, then you can write a PHP script to read each line and format it into
an INSERT query.

---John Holmes...


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php