创建学生表
1、表名Student
字段为:s_id,s_name,s_birth --学生编号,学生姓名, 出生年月,
create table Student(s_id int,s_name char(4),s_birth char(12))default charset=utf8;
2、插入字段:s_sex --学生性别
alter table Student add s_sex enum('男','女');
3、修改s_id字段为自增
alter table Student change s_id s_id int primary key auto_increment;
4、插入学生表测试数据:
'赵雷' , '1990-01-01' , '男'
'钱电' , '1990-12-21' , '男'
'孙风' , '1990-05-20' , '男'
'李云' , '1990-08-06' , '男'
'周梅' , '1991-12-01' , '女'
'吴兰' , '1992-03-01' , '女'
'郑竹' , '1989-07-01' , '女'
'王菊' , '1990-01-20' , '女'
insert into Student(s_name,s_birth,s_sex) values('赵雷' ,'1990-01-01','男'),('钱电','1990-12-21','男'),('孙风' , '1990-05-20' , '男'),('李云' , '1990-08-06' , '男'),('周梅' , '1991-12-01' , '女'),('吴兰','1992-03-01','女'),('郑竹','1989-07-01','女'),('王菊','1990-01-20','女');
5、修改出生日期是:1990-01-20的学员姓名为王舞
update Student set s_name='王舞' where s_birth=’1990-01-20’;
6、查找所有男生信息。
select * from Student where s_sex='男';