Subject | RE: [firebird-php] auto increment last insert |
---|---|
Author | Alan McDonald |
Post date | 2004-11-24T23:17:12Z |
Basically, a set-by-step approach to replacing MySQL's autoinc, without
procedures, triggers, and trying to get the value after the insert(could be
inaccurate if the generator's been used since the insert...)
[Alan McDonald] Nigel I don't think this is correct. The MySQL return of the
last insert ID is done on a connection by connection basis. If you remain
connected between tne insert and the query for lastinsert value, noone else
can ever get that value.
Alan
[Non-text portions of this message have been removed]
procedures, triggers, and trying to get the value after the insert(could be
inaccurate if the generator's been used since the insert...)
[Alan McDonald] Nigel I don't think this is correct. The MySQL return of the
last insert ID is done on a connection by connection basis. If you remain
connected between tne insert and the query for lastinsert value, noone else
can ever get that value.
Alan
[Non-text portions of this message have been removed]