Whats the preferred syntax to insert values in multiple (related) tables
I insert one record, then i need the ID of the inserted value to add it the with the other inserts
with MSSQL stored procs its
INSERT INTO ..................................... SELECT @MyID = @@IDENTITY
after that you can use @MyID
So whats the preferred method with MySQL, is there a easy way to get the Identity back from a just inserted record, or do i just have to do a select based on a value i did just insert ?
Regards Alex
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]