mcaichan.sql

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

create table mcaichan
(id int primary key auto_increment,
 dong varchar(50),
 fangjian varchar(50),
 date varchar(50),
 goods varchar(50),
 people varchar(50),
 cash varchar(50),
 peichang varchar(10)
);

insert into mcaichan values(null, 'B2','201-1','2008-12-28','凳子','admin','5','是');

insert into mcaichan values(null, 'B2','201-1','2008-12-28','桌子','admin','10','否');