【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了LoadTables1.sql相关资料,希望对各位网友有所帮助!
INSERT INTO MSPETSHOP4.CATEGORY VALUES ('FISH', 'Fish', 'Fish');
INSERT INTO MSPETSHOP4.CATEGORY VALUES ('BYARD', 'Backyard','Backyard');
INSERT INTO MSPETSHOP4.CATEGORY VALUES ('BIRDS', 'Birds', 'Birds');
INSERT INTO MSPETSHOP4.CATEGORY VALUES ('BUGS', 'Bugs', 'Bugs');
INSERT INTO MSPETSHOP4.CATEGORY VALUES ('EDANGER', 'Endangered', 'Endangered');
INSERT INTO MSPETSHOP4.SUPPLIER VALUES (1, 'XYZ Pets', 'AC', '600 Avon Way', '', 'Los Angeles', 'CA', '94024', '212-947-0797');
INSERT INTO MSPETSHOP4.SUPPLIER VALUES (2, 'ABC Pets', 'AC', '700 Abalone Way', '', 'San Francisco', 'CA', '94024', '415-947-0797');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-01', 'FISH', 'Meno', 'Your worried tiny friend warns you about life''s dangers', '~/Prod_Images/Fish/icon-meno.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-02', 'FISH', 'Balloonfish', 'It''s your thermometer - the hotter it gets the bigger it gets', '~/Prod_Images/Fish/icon-ballonfish.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-03', 'FISH', 'Blindfish', 'Likes pressure - ideal for divorcing couples', '~/Prod_Images/Fish/icon-blindfish.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-04', 'FISH', 'Crabfish', 'Dances and sings every time you feed it!', '~/Prod_Images/Fish/icon-Crabfish.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-05', 'FISH', 'Eucalyptus', 'For the tickle on your hands: you''ll love the massage', '~/Prod_Images/Fish/icon-eucalyptus.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-06', 'FISH', 'Mister No', 'Need a companion for the dark times?', '~/Prod_Images/Fish/icon-misterno.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-07', 'FISH', 'Nosyfish', 'Don''t underestimate this one - it bites!', '~/Prod_Images/Fish/icon-nosyfish.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('FI-08', 'FISH', 'Tooth Ferry', 'Very sensitive vegetarian, needs food every two months', '~/Prod_Images/Fish/icon-toothferry.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BY-01', 'BYARD', 'Sheep', 'Your soft hugging buddy', '~/Prod_Images/Backyard/icon-sheep.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BY-02', 'BYARD', 'Cat', 'The friend you will never see', '~/Prod_Images/Backyard/icon-cat.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BY-03', 'BYARD', 'Raccoon', 'Always keeps your dishes clean', '~/Prod_Images/Backyard/icon-raccoon.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BY-04', 'BYARD', 'Goose', 'For your protection delivered in our special safety-bag', '~/Prod_Images/Backyard/icon-goose.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BY-05', 'BYARD', 'Crab', 'The common house crab which lives in the refrigerator', '~/Prod_Images/Backyard/icon-crab.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BY-06', 'BYARD', 'Skunk', 'You will love it - especially when you have your in-laws visiting', '~/Prod_Images/Backyard/icon-skunk.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BY-07', 'BYARD', 'Zebra', 'The horse of the modern girl', '~/Prod_Images/Backyard/icon-zebra.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BD-01', 'BIRDS', 'Pelican', 'Will sit in your garden and admire nature', '~/Prod_Images/Birds/icon-pelican.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BD-02', 'BIRDS', 'Penguin', 'Guaranteed to stay by your side', '~/Prod_Images/Birds/icon-penguin.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BD-03', 'BIRDS', 'Pteranodon', 'Can''t let go of the past? This is your bird', '~/Prod_Images/Birds/icon-pteranodon.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BD-04', 'BIRDS', 'Owl', 'Your personal dictionary ?night & day', '~/Prod_Images/Birds/icon-owl.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BD-05', 'BIRDS', 'Duck', 'Lisps but otherwise sings well', '~/Prod_Images/Birds/icon-duck.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BG-01', 'BUGS', 'Ant', 'Trash your vacuum cleaner', '~/Prod_Images/Bugs/icon-ant.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BG-02', 'BUGS', 'Butterfly', 'Increased beauty with age', '~/Prod_Images/Bugs/icon-butterfly.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BG-03', 'BUGS', 'Spider', 'Loves a good massage', '~/Prod_Images/Bugs/icon-spider.gif');
INSERT INTO MSPETSHOP4.PRODUCT VALUES ('BG-04', 'BUGS', 'Slug', 'Your soft hugging