RE: Last Inserted Record Question

2001-09-06 Thread Dave Carter
: Thursday, September 06, 2001 5:04 PM To: Dave Carter; [EMAIL PROTECTED] Subject: Re: Last Inserted Record Question LAST_INSERT_ID() is similar. It will give you the value for autoincrement fields. Note that this is connection dependent ( so your last_insert_id() is not the same as my last_insert_i

Re: Last Inserted Record Question

2001-09-06 Thread Dana Powers
LAST_INSERT_ID() is similar. It will give you the value for autoincrement fields. Note that this is connection dependent ( so your last_insert_id() is not the same as my last_insert_id() ). You would do something like this: INSERT INTO tablex ( columnx ) VALUES ( 'valuex' ); INSERT INTO tabley (