RE: [PHP] using database to insert or update data.....
| From: | Matt Schroebel | Date: | Tue, 22 Apr 2003 15:53:42 +0000 |
| Subject: | RE: [PHP] using database to insert or update data..... | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-144851@lists.php.net to get a copy of this message | ||
> -----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');