return a newly created SID
Posted: Wed Aug 22, 2007 10:39 pm
Hi,
I was wondering if there is a good way to return a newly created SID (auto_increment) from a MySQL databse when you insert a record?
So, if I insert a record, I want to add the SID of that record to another join table... and I can expect that the SID is the only unique key in this table.
Any suggestions?
Is there a way to insert records into two tables and use that SID in the join table with one insert query?
Thanks for your assistance!
I was wondering if there is a good way to return a newly created SID (auto_increment) from a MySQL databse when you insert a record?
So, if I insert a record, I want to add the SID of that record to another join table... and I can expect that the SID is the only unique key in this table.
Any suggestions?
Is there a way to insert records into two tables and use that SID in the join table with one insert query?
Thanks for your assistance!