Re: inserting same data into multiple tables question (?)
| From: | Ignatius Reilly | Date: | Fri, 30 Apr 2004 13:09:33 +0000 |
| Subject: | Re: inserting same data into multiple tables question (?) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34202@lists.php.net to get a copy of this message | ||
You can't with standard SQL, nor with MySQL.
_________________________
----- Original Message -----
From: "JeRRy" <jusa_98@yahoo.com>
To: <php-db@lists.php.net>
Sent: Friday, April 30, 2004 3:04 PM
Subject: [PHP-DB] inserting same data into multiple tables question (?)
>
>
>
> Hi,
>
> I want to input the same data into multiple tables in
> one query if possible.
>
> So what I want to do is input about 6 usernames I have
> into about 15 tables.
>
> How would I do this? In one query? I really don't
> want to run multiple queries over 15 times to put in
> the data in each table. Would this work?
>
> INSERT into tbl1 , tbl2 , tbl3 ... ?????
>
> J
>
>
> Find local movie times and trailers on Yahoo! Movies.
> http://au.movies.yahoo.com
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>