weisheng.sql

它是用来对学生的住宿情况进行管理的一个应用 程序

create table weisheng
(id int primary key auto_increment,
 louid varchar(50),
 louceng varchar(50),
 fangjian varchar(50),  
 telephone varchar(50),
 weisheng varchar(50)
);


insert into weisheng values(null, 'B2','2层','201-1','06338711756','优');

insert into weisheng values(null, 'B2','2层','201-2','06338711757','良');

insert into weisheng values(null, 'B2','2层','201-3','06338711758','中');

insert into weisheng values(null, 'B2','2层','201-4','06338711759','及格');

insert into weisheng values(null, 'B1','2层','201-1','06338711754','差');

insert into weisheng values(null, 'B1','2层','201-2','06338711753','优');

insert into weisheng values(null, 'B1','2层','201-3','06338711752','良');

insert into weisheng values(null, 'B1','2层','201-4','06338711751','中');