sql语句

建表语句

CREATE TABLE destiny.user (
id bigint unsigned NOT NULL AUTO_INCREMENT COMMENT ‘主键id’,
name varchar(100) NOT NULL COMMENT ‘名称’,
age bigint NOT NULL DEFAULT ‘0’ COMMENT ‘年龄’,
create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘修改时间’,
address varchar(20) DEFAULT NULL COMMENT ‘地址’,
ext_info text COMMENT ‘扩展信息’,
PRIMARY KEY (id),
KEY idx_name (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=‘用户信息’;

删表语句

DROP TABLE destiny.user

表新增字段

默认null值
alter table table_name add col_name varchar(20) default null COMMENT ‘描述’
不可为null
alter table table_name add col_name varchar(20) not null COMMENT ‘描述’

表删除字段

ALTER TABLE table_name DROP COLUMN col_name