At 11:46 +0200 4/28/03, Grégoire Dubois wrote:
>I have a table "company" and a table "admin"...
>admin_ID INT (reference to an admin)
>ID INT AUTO_INCREMENT
>Is it possible to create a company and an admin in a single INSERT,
No. But you can use an AUTO_INCREMENT column in the admin_ID of the
company table. Then use LAST_INSERT_ID() to get the id for the admin
This article shows how to do it:
> and make also the admin_ID of the company be the ID of the admin.
>Make the admin_ID of the company be the ID of the admin is very
>important for me !
>Thank you very much for your Help.