Re: How do I know the auto-generated key in a newly-inserted row? bk:
> INSERT INTO Authors (fName, lName) VALUES ("Kurt", "Vonnegut");
> INSERT INTO Books (Authors.id, title) VALUES (???, "Slapstick");
>
> The ??? in the second insert is where I need help.
In case you're using PHP, have a look at mysql_insert_id()
--
Erick |