How does MySQL implement a feature like Oracle DB Sequences (Doc ID 2474698.1)

Last updated on MARCH 02, 2020

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.