> 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
> 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

Reply via email to