Sequences in mysql

[maverick19]

hi everyone
i wanted to know if we can have sequences in mysql as we have in oracle
i know one approach in which we create a table which has columns for sequence name and value but this requires a calls to the database to get the nextvalue and to increment the same.
i was wondering if anything else could be done to avoid this whole stuff

[ronverdonk]

In MySQL sequence columns are usually generated using the AUTO_INCREMENT option. That way you don't have to generate the sequence no yourself, but let MySQL do it for you with each INSERT into the table.

See also the MySQL documentation about this function at this link

Ronald :cool: