mysql 自增长sql

-- 创建一个包含自增长列的表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

-- 插入数据，无需指定id的值
INSERT INTO users (name, email) VALUES ('Alice', 'alice@example.com');
INSERT INTO users (name, email) VALUES ('Bob', 'bob@example.com');

-- 查询数据
SELECT * FROM users;

-- 重置自增长列的值
ALTER TABLE users AUTO_INCREMENT = 1;

-- 更改数据类型
ALTER TABLE users MODIFY COLUMN id BIGINT AUTO_INCREMENT;

-- 或者重置自增长列的值
ALTER TABLE users AUTO_INCREMENT = 1;

CREATE TABLE table1 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100)
) AUTO_INCREMENT = 1;

CREATE TABLE table2 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100)
) AUTO_INCREMENT = 1000;

CREATE TABLE table1 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100)
) AUTO_INCREMENT = 1 INCREMENT BY 1;

CREATE TABLE table2 (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100)
) AUTO_INCREMENT = 1 INCREMENT BY 2;