[thelist] Free Tip about SQL

Chris W. Parker cparker at swatgear.com
Fri Jul 18 12:29:36 CDT 2003


Jason Handby <mailto:jasonh at corestar.co.uk>
    on Friday, July 18, 2003 9:32 AM said:

> A much, *much* better idea is to use the built-in functionality that
> your database provides for getting the last automatically-generated
> ID.
[snip]
> In MySQL you can use LAST_INSERT_ID(). 

I'm glad this topic came up because I'm currently doing something NOT as
cool as LAST_INSERT_ID(). I'll have to give it a shot.


c.


More information about the thelist mailing list