CODEWITHSUNDEEP
mysqlsql
Lin Ma
Lin Ma

Reputation: 10149

strange error for create sequence in MySQL

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

Upvotes: 2

Views: 3466

Answers (1)

GHajba
GHajba

Reputation: 3691

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

Upvotes: 1

Related Questions