leave.sql

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

create table leaveshool
( id int primary key auto_increment,
  name varchar(20),
  xuehao varchar(20),
  sex varchar(10),
  goods varchar(50),
  onduty varchar(20),
  timeout varchar(50),
  yuangong varchar(20),
  cardid varchar(20),
  beizhu varchar(100)
);


insert into leaveshool values(null, '孙清爽','20070410140','女','无','admin','2008-12-28','1','学生证','无');

insert into leaveshool values(null, '孙娜','20070410137','女','无','admin','2008-12-28','2','身份证','无');

insert into leaveshool values(null, '张红红','20070410138','女','无','admin','2008-12-28','3','学生证','无');