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
Bras cause cancer. And tiny ads:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
|