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
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1273
CACHE 1;
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1273
CACHE 1;
----------------------------------
学习了!
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