guest.sql

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

create table guest
( id int primary key auto_increment,
  seename varchar(20),
  comename varchar(20),
  cometime varchar(50),
  gotime varchar(50),
  guanxi varchar(50),
  onduty varchar(50),
  cardid varchar(50),
  beizhu varchar(100)
);


insert into guest values(null,'苏兰兰','苏国丛','2008-12-28','','朋友','admin','学生证','无');

insert into guest values(null,'孙清爽','孙清杰','2008-12-28','','朋友','admin','身份证','无');