mysql命令行创建表，插入表数据

mysql命令行创建表，插入表数据

create table t_hero(
id int unsigned auto_increment primary key,
name varchar(10) unique not null,
age tinyint unsigned default 0,
gender set("男", "女"),
state varchar(10)
);

 

 

insert into studentapp_student (name,age,sex,address)
values
("Lisa",20,"女","河北唐山"),
("张强",18,"男","河南安阳"),
("丽丽",28,"女","江苏南京")

posted @ 2018-11-22 09:31 独爱米粒 阅读( ...) 评论( ...) 编辑 收藏