strange error for create sequence in MySQL

Question

Here is the code and error message, and any hints are appreciated. Using My SQL Workbench/MySQL,

CREATE SEQUENCE seq_person                                
MINVALUE 1
START WITH 1
INCREMENT BY 1
CACHE 10

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SEQUENCE seq_person                                #how to? MINVALUE 1 START WIT' at line 1

thanks in advance, Lin

@Barmar, what is the equivalent implementation/statement in MYSQL? — Lin Ma
– Lin Ma, Commented Aug 27, 2015 at 6:45
MySQL uses the AUTO_INCREMENT option on the primary key column of the table. — Barmar
– Barmar, Commented Aug 27, 2015 at 6:45
Got it, thanks. Could you reply as answer so that I can mark as answer to benefit other people (include Google :P)? :) — Lin Ma
– Lin Ma, Commented Aug 27, 2015 at 6:45

GHajba · Accepted Answer · 2015-08-27 06:45:45Z

1

Actually MySQL does not have a SEQUENCE. However you can use AUTO_INCREMENT columns just like described here: http://www.tutorialspoint.com/mysql/mysql-using-sequences.htm

answered Aug 27, 2015 at 6:45

GHajba

3,7215 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lin Ma Over a year ago

in 6 mins. For sure. Take a Cafe. :)

Collectives™ on Stack Overflow

strange error for create sequence in MySQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related