常用mysql建表sql

CREATE database IF NOT EXISTS test_db;
ALTER DATABASE test_db CHARACTER SET utf8 COLLATE utf8_general_ci;
use echarts;

DROP TABLE IF EXISTS test_table;
CREATE TABLE IF NOT EXISTS test_table (
    id BIGINT(22) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
    field1 VARCHAR(128) NOT NULL COMMENT 'field1',
    field2 VARCHAR(128) COMMENT 'field2',
    field3 VARCHAR(256) COMMENT 'field3',
    inserttime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '插入时间',
    updatetime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    isactive TINYINT(1) NOT NULL DEFAULT '1' COMMENT '逻辑删除(1:保留,0:删除)',
    PRIMARY KEY (id)
) ENGINE = InnoDB,
DEFAULT CHARSET = utf8mb4,
COLLATE = utf8mb4_unicode_ci,
COMMENT = '测试表';

-- 唯一索引
CREATE UNIQUE INDEX idx_field1 ON test_table(field1);

-- 清空表
-- truncate test_table;

INSERT test_table(field1,field2,field3)
VALUES
('','',''),
('','','');