insertvalues.sql

一个网上购物商城系统

insert into category(cname,parentid,description,ctype) values ('保温杯',36,'保温杯',3);


--insert Brand

insert into brand (en_name,cn_name) values ('Disney','迪士尼');
insert into brand (en_name,cn_name) values ('Belkin','贝尔金');
insert into brand (en_name,cn_name) values ('TARGUS','泰格斯');
insert into brand (en_name,cn_name) values ('HP','惠普');
insert into brand (en_name,cn_name) values ('SUMDEX','森泰斯');
insert into brand (en_name,cn_name) values ('GD','礼想家');
insert into brand (en_name,cn_name) values ('actto','安尚');
insert into brand (en_name,cn_name) values ('CANON','佳能');
insert into brand (en_name,cn_name) values ('Logitech','罗技');
insert into brand (en_name,cn_name) values ('Apple','苹果');
insert into brand (en_name,cn_name) values ('3NOD','三诺');

commit;

insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P1',38,6,395.45,date '2008-10-4',39,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P2',66,2,653.15,date '2008-10-4',6,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P3',90,6,32.16,date '2008-10-4',63,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P4',64,5,514.7,date '2008-10-4',17,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P5',87,10,283.98,date '2008-10-4',19,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P6',49,8,26.21,date '2008-10-4',6,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P7',75,4,890.41,date '2008-10-4',36,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P8',54,1,323.64,date '2008-10-4',29,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P9',37,1,611.78,date '2008-10-4',65,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P10',77,8,274.6,date '2008-10-4',34,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P11',43,10,544.69,date '2008-10-4',63,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P12',95,10,488.3,date '2008-10-4',22,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P13',57,3,317.74,date '2008-10-4',9,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P14',41,6,539.15,date '2008-10-4',64,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P15',66,10,229.45,date '2008-10-4',97,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P16',41,4,89.29,date '2008-10-4',69,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P17',40,8,687.74,date '2008-10-4',47,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P18',72,5,306.66,date '2008-10-4',20,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P19',76,4,806.88,date '2008-10-4',6,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P20',54,1,158.86,date '2008-10-4',93,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P21',70,10,84.03,date '2008-10-4',61,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P22',55,7,241.97,date '2008-10-4',41,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P23',82,2,751.53,date '2008-10-4',40,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P24',94,1,497.34,date '2008-10-4',27,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P25',87,7,646.17,date '2008-10-4',22,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P26',97,9,744.68,date '2008-10-4',14,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P27',66,6,385.39,date '2008-10-4',64,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P28',94,5,480.08,date '2008-10-4',39,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P29',67,6,849.89,date '2008-10-4',64,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P30',46,9,963.57,date '2008-10-4',15,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P31',52,3,668.26,date '2008-10-4',5,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P32',49,1,658.73,date '2008-10-4',5,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P33',58,5,732.91,date '2008-10-4',56,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P34',97,2,542.14,date '2008-10-4',42,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P35',39,2,68.04,date '2008-10-4',35,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P36',40,3,423.14,date '2008-10-4',93,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P37',98,4,363.67,date '2008-10-4',85,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P38',47,5,2.22,date '2008-10-4',11,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P39',45,1,598.68,date '2008-10-4',65,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P40',58,6,45.24,date '2008-10-4',61,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P41',49,2,738.97,date '2008-10-4',49,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P42',51,10,400.41,date '2008-10-4',37,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P43',97,1,21.23,date '2008-10-4',64,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P44',58,7,76.09,date '2008-10-4',95,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P45',55,8,750.74,date '2008-10-4',41,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P46',48,9,713.13,date '2008-10-4',11,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P47',60,10,454.01,date '2008-10-4',71,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P48',76,6,310.2,date '2008-10-4',44,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P49',62,4,160.17,date '2008-10-4',65,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P50',94,5,321.23,date '2008-10-4',56,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P51',92,6,232.97,date '2008-10-4',50,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P52',38,8,368.38,date '2008-10-4',72,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P53',58,9,658.69,date '2008-10-4',26,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P54',75,8,974.04,date '2008-10-4',65,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P55',92,3,801.42,date '2008-10-4',56,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P56',70,10,380.68,date '2008-10-4',16,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P57',71,5,80.96,date '2008-10-4',39,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P58',60,8,714.9,date '2008-10-4',14,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P59',75,8,690.96,date '2008-10-4',21,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P60',54,1,275.88,date '2008-10-4',95,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P61',86,5,663.95,date '2008-10-4',52,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P62',64,3,446.88,date '2008-10-4',33,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P63',75,10,281.08,date '2008-10-4',16,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P64',37,9,801.68,date '2008-10-4',70,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P65',82,6,919.12,date '2008-10-4',67,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P66',76,4,107.25,date '2008-10-4',11,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P67',48,5,994.73,date '2008-10-4',87,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P68',90,4,611.94,date '2008-10-4',13,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P69',78,4,201.31,date '2008-10-4',18,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P70',83,9,803.14,date '2008-10-4',13,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P71',84,8,900.76,date '2008-10-4',43,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P72',87,3,562.92,date '2008-10-4',80,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P73',72,7,418.14,date '2008-10-4',68,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P74',59,10,738.16,date '2008-10-4',1,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P75',82,3,351.15,date '2008-10-4',1,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P76',92,6,759.87,date '2008-10-4',27,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P77',55,8,528.22,date '2008-10-4',0,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P78',40,7,331.38,date '2008-10-4',7,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P79',55,3,282.08,date '2008-10-4',37,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P80',87,3,888.43,date '2008-10-4',39,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P81',45,5,523.81,date '2008-10-4',49,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P82',81,3,594.81,date '2008-10-4',42,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P83',98,7,152.56,date '2008-10-4',82,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P84',54,8,952.36,date '2008-10-4',43,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P85',45,10,485.54,date '2008-10-4',41,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P86',53,7,594.43,date '2008-10-4',17,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P87',95,7,182.77,date '2008-10-4',7,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P88',98,6,719.63,date '2008-10-4',73,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P89',70,9,32.04,date '2008-10-4',91,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P90',46,6,672.44,date '2008-10-4',47,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P91',70,7,586.65,date '2008-10-4',86,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P92',49,9,953.37,date '2008-10-4',67,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P93',62,3,66.41,date '2008-10-4',58,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P94',90,1,54.48,date '2008-10-4',95,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P95',67,10,869.03,date '2008-10-4',48,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P96',54,4,872.38,date '2008-10-4',74,false);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P97',87,8,144.3,date '2008-10-4',96,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P98',83,7,505.77,date '2008-10-4',89,true);
insert into product(pname,cid,bid,price,addtime,viewpopluarity,promotion) values ('P99',46,2,977.43,date '2008-10-4',31,false);


commit;


insert into productattention (sessionid,pid, attentiontime) values ('SID-5124897355825159418',47,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID1787252237805158574',53,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2015164554181801367',58,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID969805272110915221',89,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-7158002580391631067',34,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID7888929133061315266',92,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-6711487864346088864',43,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID6575761589523422368',47,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2084101199374835555',22,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-4044924516192086197',76,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID-2420623595746422153',54,date '2008-11-10');
insert into productattention (sessionid,pid, attentiontime) values ('SID8940720422129947661',78,date '2008-11-10');