To be honest I have no idea (just learning SQL myself) but the MySQL manual does offer at least a few tips to help opitmize your insert statements in looped scenarios... http://www.mysql.com/doc/I/n/Insert_speed.html -Kevin
----- Original Message ----- From: "Leif K-Brooks" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 31, 2002 1:12 PM Subject: [PHP-DB] Mutiple inserts with one query? > Is there a way to insert multiple identical rows in one mysql query? > I'm using a looped query right now, which uses more server load than it > should... Thanks! > > > -- > 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