water.sql

来自「它是用来对学生的住宿情况进行管理的一个应用 程序」· SQL 代码 · 共 23 行

create table water
( id int primary key auto_increment,
  louhao varchar(20),
  fangjianhao varchar(20),
  bdata varchar(50),
  waterd varchar(20),
  waterx varchar(20),
  water varchar(20),
  diand varchar(20),
  dianx varchar(20),
  dian varchar(20),
  zong varchar(20)
);



insert into water values(null, 'B2','201','2008-10-28','10','20','8','10','20','6','14');

insert into water values(null, 'B2','202','2008-10-28','10','20','8','10','20','6','14');

insert into water values(null, 'B2','201','2008-11-28','20','30','8','20','30','6','14');

insert into water values(null, 'B2','201','2008-12-28','30','40','8','30','40','6','14');