Re: bulk miorting rows into mysql db
| From: | 1LT John W. Holmes | Date: | Fri, 13 Dec 2002 19:36:03 +0000 |
| Subject: | Re: bulk miorting rows into mysql db | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24135@lists.php.net to get a copy of this message | ||
> 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...