Hi All

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]



Reply via email to