How does MySQL implement a feature like Oracle DB Sequences
(Doc ID 2474698.1)
Last updated on MARCH 02, 2020
Applies to:
MySQL Server - Version 5.0 and laterInformation in this document applies to any platform.
Goal
Need help in understanding how to create and use sequences in MySQL (coming from oracle background).
The best fit thing I could get is AUTO_INCREMENT attribute but still not able to figure out how to fetch LAST_INSERT_ID() corresponding to different tables.
There are some hints in official documentations about LAST_INSERT_ID() returning values per connection.
But couldn't find the definition of connection viz., Is it a user session from any IDE/Editor, a jdbc connection (pooled vs non-pooled), MySQL Workbench ?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |