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;