sql:
创建序列序列序列系统日志,以1乘以1开始
CREATE SEQUENCE seq_sys_log START WITH 1 INCREMENT BY 1;
1、sequence的基本用法:
[sql] view plain copy
- create sequence SEQ_ON_USER
- minvalue 1
- maxvalue 999999999999999999999999999
- start with 1
- increment by 1
- nocache;
说明:
minvalue:序列最小值
maxvalue/nomaxvalue:序列最大值/没有最大值
start with 1:序列从1开始
increment by 1:每次增加1
cache/nocache:nocache不缓存。cache缓存。开启缓存,效率高,只是如果数据库宕机了,缓存丢失,会出现序列跳号情况。
2、查看已