Inserting into multiple tables using Auto Incremented Field

[Ryan Hubbard]

I'm inserting a record into MySQL 4.0 using Visual Basic ADO. When
using the AddNew and Update method I am unable to retrieve the value
of a Auto incrment field (Yes I know I can MoveLast but this icreases
the update time by a factor of 10 and when your talking about 200,000
inserts its way to long). Is there a way to insert the record into
multiple tables in one statement where you can use the value of the
auto incremented field as the key in the second table? So the
statement inserts the record into a table retrieves the new
auto_incremente d key and then insterts information into the second
table using the incremented key as the primary key? Thanks

[Aggro]

Ryan Hubbard wrote:

inserts its way to long). Is there a way to insert the record into
multiple tables in one statement where you can use the value of the
auto incremented field as the key in the second table? So the

This is possible only with (atleast) two queries.
INSERT INTO foo (auto,text) VALUES(NULL,'te xt');
INSERT INTO foo2 (id,text) VALUES(LAST_INS ERT_ID(),'text' );

http://dev.mysql.com/doc/mysql/en/OD...insert_id.html