MYSQL 创建表

2020-10-19  本文已影响0人  dhz120

模板:

CREATE TABLE customer
( 
    id             BIGINT(20) PRIMARY KEY AUTO_INCREMENT NOT NULL,
    create_time    DATETIME DEFAULT CURRENT_TIMESTAMP,
    update_time    DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    version        INT DEFAULT 1,
    deleted        INT DEFAULT 0,
    name           VARCHAR(20) UNIQUE,
    age            INT
) ENGINE=InnoDB DEFAULT CHARSET=UTF8 AUTO_INCREMENT=1;
上一篇下一篇

猜你喜欢

热点阅读