1、 create table xs (stu_code varchar(20),
name varchar(20),
birth_date varchar(20),
marital_status varchar(10)
)
2、 insert into xs (stu_code,name,marital_status) values ('02200703100','张三','未婚')
3、 alter table xs add qq varchar(10);
update xs set xs.qq = '4532789' where xs.name = '张三';
4、 update xs set xs.birth_date = '1992-5-5' where xs.name = '李四';
5、 select * from xs where xs.marital_status = '已婚';
追问
大神,能帮我再看一下这个E-R图吗