get AUTO INCREMENT and store into a separate table

[SeanHarding]

INSERT INTO table1(id, chicken, beef, pork), table2(id, lettuce, cucumber) VALUES (NULL, '21', '22','23', NULL, '12', '13');

 

Is there a way to retrieve the AUTO INCREMENT of table1 id and insert it into table2 lettuce all within MySQL code?

 

I can do this in PhP by mysql_insert_id(); but that would mean two MySQL queries.

 

Sorry if my query is written incorrectly, was just a passing thought.

[Andy-H]

 

MySQL's LAST_INSERT_ID()

[SeanHarding]

 

MySQL's LAST_INSERT_ID()

 

INSERT INTO table1(id, chicken, beef, pork), table2(id, chickenid, cucumber) VALUES (NULL, '21', '22', '23', NULL, LAST_INSERT_ID(), '13') ??

[fenway]

There's no such thing as a multi-table insert.