CREATE SEQUENCE seq
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1273
CACHE 1;
这个语句,我在mySQL4.1上运行不成功呀。好象没create sequence 这个命令。
具体信息如下:
mysql> CREATE SEQUENCE seq
-> INCREMENT 1
-> MINVALUE 1
-> MAXVALUE 9223372036854775807
-> START 1273
-> CACHE 1;
ERROR 1064 (42000): 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 'SEQUE