mysql 建表语句

CREATE DATABASE lookalikeexpansions;

CREATE TABLE IF NOT EXISTS lookalike_task_info(
id bigint(11) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
seedUserPath VARCHAR(100) NOT NULL DEFAULT ‘’ COMMENT ‘seedUserPath’,
country varchar(100) NOT NULL DEFAULT ‘NA’ COMMENT ‘country’,
targetUserNum bigint(11) NOT NULL DEFAULT ‘20000’ COMMENT ‘targetUserNum’,
groupCode varchar(100) NOT NULL DEFAULT ‘’ COMMENT ‘groupCode’ ,
requestId varchar(100) NOT NULL DEFAULT ‘’ COMMENT ‘requestId’,
includeSeed int(4) DEFAULT ‘0’ COMMENT ‘includeSeed’,
limitUserPath varchar(100) NOT NULL DEFAULT ‘’ COMMENT ‘limitUserPath’,
appId varchar(100) NOT NULL DEFAULT ‘’ COMMENT ‘appId’ ,
s3Path varchar(100) NOT NULL DEFAULT ‘’ COMMENT ‘s3Path’ ,
taskStatus int(4) DEFAULT ‘0’ COMMENT ‘状态’,
createTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’ ,
startTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘开始时间’ ,
endTime datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT ‘结束时间’,
PRIMARY KEY ( id )
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT=‘人群扩散任务表’;

数据创建时间用 CURRENT_TIMESTAMP —insert此条数据的时间（之后就不变了）
数据更新时间用 UPDATE CURRENT_TIMESTAMP—update此条数据的时间（数据字段有变更时，会更新为当前时间）

建表语句

alter table lookalike_reqest_info modify seedUserPath varchar(1000) COMMENT ‘seedUserPath’,
modify limitUserPath varchar(1000) COMMENT ‘limitUserPath’,
modify s3Path varchar(1000) COMMENT ‘s3Path’;

修改字段长度