You can't with standard SQL, nor with MySQL. _________________________ ----- Original Message ----- From: "JeRRy" <jusa_98@xxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Sent: Friday, April 30, 2004 3:04 PM Subject: 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 > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php