Getting New RecID after SQL INSERT, Frank?

[Frank Schima]

On Aug 20, 2004, at 3:19 PM, Ruslan Zasukhin wrote:

> On 8/20/04 9:46 PM, "Frank Schima" <frank-list2 at mindstarprods.com> 
> wrote:
>
>>>>> FS> Usually they have a SQL way to do that. For instance in MySQL 
>>>>> it
>>>>> is:
>>>>>
>>>>> FS>     SELECT LAST_INSERT_ID()
>>>
>>> Frank,
>>>
>>> Please remind me,
>>>
>>> Since mySQL is RDBMS,
>>>
>>> And PK can be any type, then this function can return integer, double
>>> or
>>> string value, yes?
>>
>> It can only be used with auto-increment fields which are integers.
>
> Hmm. You sure ?
>
> I do not see technical problems for mySQL to return different types.

AFAIK:

<http://dev.mysql.com/doc/mysql/en/Getting_unique_ID.html>


-Frank