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
lt;[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 06, 2001 1:24 PM Subject: Last Inserted Record Question > Access and MS-SQL Server have a method called @@IDENTITY used in retrieving > the last inserted ID of a recordset. Is mySQL ok with that command. I > supp

Last Inserted Record Question

2001-09-06 Thread Dave Carter
Access and MS-SQL Server have a method called @@IDENTITY used in retrieving the last inserted ID of a recordset. Is mySQL ok with that command. I suppose I could try it, but I'm interested in views etc. also. Dave Carter Chief Web Architect Accelerated Business Technologies, Inc. http://www.abti