MySql创建表

MySql创建表 语句如下：

DROP table if exists `user`;   --如果表存在则先删除表

create table `user` (

`id` varchar(36) character set utf8mb4 collate utf8mb4_general_ci not null comment '主键',

`name` varchar(36) character set utf8mb4 collate utf8mb4_general_ci not null comment '名称'

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

insert into `user` values ('1260185893546840066','a');

insert into `user` values ('1260185893546840067','b');