# orderId_by_sequence

**Repository Path**: sakurachan/mysql_sequence

## Basic Information

- **Project Name**: orderId_by_sequence
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-05-27
- **Last Updated**: 2025-05-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

资料:

https://blog.csdn.net/u012724167/article/details/78316392

```
CREATE SEQUENCE SYSORDERID
    START WITH 20754
    INCREMENT BY 1
    MINVALUE 1
    MAXVALUE 9223372036854775806
    CACHE 1000
    CYCLE;

-- 获取下一个值
SELECT NEXT VALUE FOR SYSORDERID;

-- 获取当前值（注意：必须先调用NEXT VALUE才能使用）
SELECT PREVIOUS VALUE FOR SYSORDERID;

-- 设置序列值（通过删除重建实现）
DROP SEQUENCE SYSORDERID;
CREATE SEQUENCE SYSORDERID
    START WITH 30000  -- 设置新的起始值
    INCREMENT BY 1
    MINVALUE 1
    MAXVALUE 9223372036854775806
    CACHE 1000
    CYCLE;

```