mysql操作命令（一）

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`)
)