kunal
LAST_INSERT_ID() (with no argument) returns a BIGINT (64-bit) value representing the first automatically generated value that was set for an AUTO_INCREMENT column by the most recently executed INSERT statement to affect such a column.
kunal
kunal
Bear Bibeault wrote:Why aren't you using a sequence?
Claude Moore wrote:or if I cannot let gaps in my sequences, when rollbacks may happen ?
UPDATE INVOICE SET INVOICE_NBR = NEXT VALUE FOR INVOICE_COUNTER.
kunal
Consider Paul's rocket mass heater. |