inserttable.sql

自己做的影碟碟出租管理系统

insert into disc values('一','赵','大陆','2001 ','动作',5,6,1);
insert into disc values('二','钱','港台','2002','喜剧',5,6,1);
insert into disc values('三','孙','大陆','2001','爱情',10,11,1);
insert into disc values('四','李','欧美','2002','科幻',10,11,1);
insert into disc values('五','周','港台','2007','动作',15,15,1);
insert into disc values('六','吴','大陆','2005','悬疑',4,5,1);
insert into disc values('七','郑','日韩','2003','科幻',15,15,1);
insert into disc values('八','王','大陆','2005','恐怖',10,10,1);
insert into disc(dname,role,area,time,type,totlenumber,currentnumber,price) values('功夫之王','李连杰','欧美','2008','动作',5.0,5.0,2.0)
insert into disc(dname,role,area,time,type,totlenumber,currentnumber,price) values('游侠','李连杰','欧美','2007','动作',5.0,5.0,2.0)
insert into disc(dname,role,area,time,type,totlenumber,currentnumber,price) values('国家宝藏','尼古拉斯.凯奇','欧美','2008','动作',5.0,5.0,2.0)
insert into disc values('集结号','谷子地','大陆','2007','战争',2,2,1);
insert into disc values('苹果','范冰冰 佟大为','大陆','2007','伦理',2,2,1);
insert into disc values('风语者','尼古拉斯.凯奇','欧美','2007','战争',10,10,1);
insert into disc values('独立日','威尔.斯密斯','欧美','2007','科幻',10,11,1);
insert into disc values('出埃及记','任达华 温碧霞','港台','2007','伦理',15,16,1);
insert into disc values('心灵捕手','罗宾.威廉姆斯','欧美','2007','剧情',15,17,1);
insert into disc values('投名状','李连杰 刘德华 金城武','大陆','2007','动作',21,21,1);
insert into disc values('地狱男爵','罗.皮尔曼','欧美','2007','科幻',12,12,1);
insert into disc values('料理鼠王','##','欧美','2007','卡通',15,16,1);

insert into admininfo values('iove','454693');


insert into userinfo values('a','a',0);
insert into userinfo values('b','b',0);
insert into userinfo values('c','c',0);


insert into rent values('a','一','08.5.3');
insert into rent values('a','三','08.5.9');
insert into rent values('b','六','08.1.7');
insert into rent values('b','四','08.1.13');
insert into rent values('c','二','08.1.16');

select *from userinfo
select *from admininfo
select *from disc
select * from rent