On Wed, 24 Sep 2003 14:23:04 -0500 "Dan J. Rychlik" <[EMAIL PROTECTED]> wrote:
> Hello, > > I have a question about INSERTing data into 2 different tables with one statement. > Can you do this? > > INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ',' > USERPHONE') AND table2 (name) VALUES( ' USER '); No. Use 2 queries for that: INSERT INTO table1 (name,address,phone) VALUES ( ' USER ', ' USERADDY ',' USERPHONE'); INSERT INTO table2 (name) VALUES( ' USER '); --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]