> > You can use the @@IDENTITY value to return the last autoincremented
> > value:
> This is available in versions of MySQL >= 3.23.25. It
> is a synonym for
> the native MySQL construct:
> SELECT LAST_INSERT_ID()
> in order to make MySQL more compatible with other databases.
FWIW, there's also a bug in certain versions of MySQL(fixed in current) when using "@@identity"(lower case). Something to keep in mind...
--
Derek
©2004 Derek J. Kalweit |
