mysql新增、修改表字段

• 在t_user表，新增字段update_time

alter table t_user add column update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP; 

• 在t_user表，修改字段user_name ——> name

alter table t_user change `user_name` `name` varchar(64) DEFAULT NULL; 

• 批量修改字段

ALTER TABLE template_sentence CHANGE sentenceId `sentence_id` BIGINT (20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
 CHANGE userId `user_id` INT (11) UNSIGNED NOT NULL COMMENT '用户ID',
 CHANGE templateId `template_id` INT (11) UNSIGNED NOT NULL COMMENT '模板ID',
 CHANGE isTrigger `is_trigger` TINYINT (6) UNSIGNED DEFAULT '0' COMMENT '表示is on dialog, 0: 不以对话状态为触发条件， 1:以对话状态为触发条件',
 CHANGE appKey `app_key` VARCHAR (1000) DEFAULT NULL,
 CHANGE businessType `business_type` TINYINT (6) UNSIGNED NOT NULL DEFAULT '1' COMMENT '属于的业务；1-通用；2-语音；3-语义',
 CHANGE dr `is_deleted` TINYINT (6) UNSIGNED NOT NULL DEFAULT '0' COMMENT '删除标志';