mpubcaichan.sql

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

create table mpubcaichan
(id int primary key auto_increment,
 pubstuid varchar(50),
 pubname varchar(50),
 pubdate varchar(50),
 pubgoods varchar(50),
 pubyear varchar(50),
 pubcash varchar(50),
 pubpeichang varchar(10)
);

insert into mpubcaichan values(null, '20070410138','张红红','2008-12-28','桌子','2008','10','是');
insert into mpubcaichan values(null, '20070410137','孙娜','2008-12-28','门','2008','20','是');