Mysql命令ddl语句

1.先查看整个表的建表语句

SHOW CREATE TABLE `system_user`;

CREATE TABLE `system_user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
  `nickname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户昵称',
  `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '头像地址',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '密码',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
  `flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `expirationTime` datetime DEFAULT NULL COMMENT '更新时间',
  `token` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='用户信息表'

2.新增字段DDL

ALTER TABLE `system_user` ADD COLUMN `remark` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '备注,比如出自哪本书籍';

3.修改字段DDL

 ALTER TABLE `system_user` MODIFY COLUMN `avatar` varchar(50) NOT NULL DEFAULT '' COMMENT '头像地址';