Re: bulk miorting rows into mysql db
| From: | Adam Williams | Date: | Fri, 13 Dec 2002 19:21:21 +0000 |
| Subject: | Re: bulk miorting rows into mysql db | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24133@lists.php.net to get a copy of this message | ||
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:mikek@brightstorm.co.uk - phone:0117 9426653
> brightstorm - curiously online - http://www.brightstorm.co.uk
>
>
>