Link to home
Start Free TrialLog in
Avatar of srikotesh
srikotesh

asked on

when to use sequences in mysql

Hi Experts,

I want to know when we need to use sequences.
I am trying to create the below sequence but i am unable to add.
Please suggest me how add the below sequence query into my database.

CREATE SEQUENCE BATCH_JOB_SEQ MAXVALUE 9223372036854775807 NO CYCLE;

Thanks
ASKER CERTIFIED SOLUTION
Avatar of VanDongen Consulting
VanDongen Consulting
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Tomas Helgi Johannsson
Tomas Helgi Johannsson
Flag of Iceland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of srikotesh
srikotesh

ASKER

Thanks