tdsql_ 접두사가 있어야 하고 proxy 버전은 1.19.5-M-V2.0R745D005 이상이어야 합니다. /*Proxy*/show status 문을 실행하여 proxy 버전을 볼 수 있습니다. proxy가 이전 버전에 있는 경우 티켓 제출하여 업그레이드할 수 있습니다.CREATE TDSQL_SEQUENCE 시퀀스 이름[START WITH n][{TDSQL_MINALUE/ TDSQL_MAXMINVALUE n| TDSQL_NOMAXVALUE}][TDSQL_INCREMENT BY n][{TDSQL_CYCLE|TDSQL_NOCYCLE}]
create tdsql_sequence test.s1 start with 12 tdsql_minvalue 10 maxvalue 50000 tdsql_increment by 5 tdsql_nocyclecreate tdsql_sequence test.s2 start with 12 tdsql_minvalue 10 maxvalue 50000 tdsql_increment by 1 tdsql_cycle
drop tdsql_sequence test.s1
show create tdsql_sequence test.s2
select tdsql_nextval(test.s2)select next value for test.s2
mysql> select tdsql_nextval(test.s1);+----+| 12 |+----+| 12 |+----+1 row in set (0.18 sec)mysql> select tdsql_nextval(test.s2);+----+| 12 |+----+| 12 |+----+1 row in set (0.13 sec)mysql> select tdsql_nextval(test.s1);+----+| 17 |+----+| 17 |+----+1 row in set (0.01 sec)mysql> select tdsql_nextval(test.s2);+----+| 13 |+----+| 13 |+----+1 row in set (0.00 sec)mysql> select next value for test.s1;+----+| 22 |+----+| 22 |+----+1 row in set (0.01 sec)
mysql> select * from test.t1;+----+------+| a | b |+----+------+| 11 | 2 |+----+------+1 row in set (0.00 sec)mysql> insert into test.t1(a,b) values(tdsql_nextval(test.s2),3);Query OK, 1 row affected (0.01 sec)mysql> select * from test.t1;+----+------+| a | b |+----+------+| 11 | 2 || 14 | 3 |+----+------+2 rows in set (0.00 sec)
select tdsql_lastval(test.s1)select tdsql_previous value for test.s1;
mysql> select tdsql_lastval(test.s1);+----+| 22 |+----+| 22 |+----+1 row in set (0.00 sec)mysql> select tdsql_previous value for test.s1;+----+| 22 |+----+| 22 |+----+1 row in set (0.00 sec)
select tdsql_setval(test.s2,1000,bool use) // use는 기본적으로 1이며, 이는 1000 값이 사용되었으며 다음 값은 1000이 아님을 나타냅니다. use가 0이면 다음 값은 1000부터 시작합니다.
mysql> select tdsql_nextval(test.s2);+----+| 15 |+----+| 15 |+----+1 row in set (0.01 sec)mysql> select tdsql_setval(test.s2,10);+---+| 0 |+---+| 0 |+---+1 row in set (0.03 sec)mysql> select tdsql_nextval(test.s2);+----+| 16 |+----+| 16 |+----+
mysql> select tdsql_setval(test.s2,20);+----+| 20 |+----+| 20 |+----+1 row in set (0.02 sec)mysql> select tdsql_nextval(test.s2);+----+| 21 |+----+| 21 |+----+1 row in set (0.01 sec)
select tdsql_resetval(test.s2,1000)
mysql> select tdsql_resetval(test.s2,14);+----+| 14 |+----+| 14 |+----+1 row in set (0.00 sec)mysql> select tdsql_nextval(test.s2);+----+| 14 |+----+| 14 |+----+1 row in set (0.01 sec)
TDSQL_ 접두사가 붙습니다.TDSQL_CYCLETDSQL_INCREMENTTDSQL_LASTVALTDSQL_MINVALUETDSQL_NEXTVALTDSQL_NOCACHETDSQL_NOCYCLETDSQL_NOMAXVALUETDSQL_NOMINVALUETDSQL_PREVIOUSTDSQL_RESTARTTDSQL_REUSETDSQL_SEQUENCETDSQL_SETVAL
피드백