1、创建表
create table `user`( `id` int(4) primary key, `user_name` varchar(10) not null, `user_dept` int(4) null, `remark` varchar(100) null, `create_time` date null, `update_time` date null, `create_user` VARCHAR(10), `update_user` varchar(10), `status` int(2) null )
2、插入字段
alter table `dept` add column `desc` varchar(50) null after `name`, add column `remark` varchar(100) null after `desc`, add column `createUser` varchar(10) null after `remark`, add column `updateUser` varchar(10) null after `createUser`, add column `status` int(2) null after `updateUser`;
3、添加字段注释
ALTER TABLE `user` MODIFY COLUMN `id` int(4) NOT NULL COMMENT '用户编号' FIRST , modify column `user_name` varchar(10) character set utf8 collate utf8_general_ci not null comment '用户名' after `id`, modify column `user_dept` varchar(100) character set utf8 collate utf8_general_ci null comment '所属部门' after `user_name`;
4、新建表并对字段添加注释
create table `user_information`( `id` int(4) not null comment 'id', `user_id` int(4) null comment '用户id', `tel` varchar(25) null comment '联系电话', `email` varchar(50) null comment '联系邮箱', `address` varchar(255) null comment '住宅地址', `remark` varchar(255) null comment '备注', `create_time` datetime null on update current_timestamp, `update_time` datetime null on update current_timestamp, `create_user` int(4) null comment '创建用户', `update_user` int(4) null comment '更新用户', `status` int(2) null, primary key(`id`) )
