You could try creating a function in Java or C/C++ or whatever your preference is that wraps the select statements up for you and returns the insert ID.
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/24/04, 11:02:51 AM, David Scott <[EMAIL PROTECTED]> wrote regarding INSERT returning ID: > Hi list peeps.... > In many of my projects I have the need to insert a new record into a > table and then later on in the script update this record, Right now I am > doing this by doing the insert, then immediately doing a Select to > return the latest id (unique id) which I store later for my update. > Is there any way I can do an insert and have it return the unique > auto-assigned id? > Cheers > Dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
