My Oracle Support Banner

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 later
Information 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


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