Re: using database to insert or update data.....
| From: | Scott Fletcher | Date: | Tue, 22 Apr 2003 16:07:35 +0000 |
| Subject: | Re: using database to insert or update data..... | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-144852@lists.php.net to get a copy of this message | ||
Ah!!! I didn't know there is such a feature as this. I'll check it out...
Thanks,
FletchSOD
"Matt Schroebel" <MSchroebel@hsus.org> wrote in message
news:D4DB668A680B2549AE977FB0B193E2E86DD7D3@email.hsus.org...
> -----Original Message-----
> From: Scott Fletcher [mailto:scott@abcoa.com]
> Sent: Tuesday, April 22, 2003 11:33 AM
> To: php-general@lists.php.net
> Subject: [PHP] using database to insert or update data.....
>
> I wonder if there is an easier way to insert like 50 rows
> of data into
> the database all at once. Instead of something like one row
> at a time, then
> verify if it is successfull then move on to the next row and repeat...
>
Is this what you mean? It inserts 2 rows:
INSERT INTO
table (col1,col2)
values('a','b'),('c','d');