insert_data.sql

来自「This is a book about vb.you could learn 」· SQL 代码 · 共 702 行 · 第 1/5 页

INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416249', 34.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416125', 62.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416400', 65.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416397', 62.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416370', 62.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416346', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416311', 62.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416303', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('187441629X', 34.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002564', 44.5, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416265', 39.15, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416494', 62.95, 'CAN')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416222', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416214', 34.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416206', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416192', 41.15, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416184', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416176', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416168', 37.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('187441615X', 39.15, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416133', 51.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416273', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416672', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861000065', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861004753', 52.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416923', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416877', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416869', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416826', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416788', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416745', 51.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416478', 62.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416680', 51.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416443', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416664', 55.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416656', 34.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416648', 51.99, 'CAN')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416605', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416591', 51.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416575', 34.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416559', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416532', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416508', 41.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416699', 69.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002726', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002947', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002939', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002904', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002882', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002874', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002858', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002815', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002610', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002963', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002750', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002807', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002718', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100270X', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002696', 89.99, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002688', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002653', 44.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002645', 74.95, 'CAN')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416117', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002580', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416486', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002785', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003986', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002777', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861004222', 52.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002971', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003811', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003668', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003463', 112.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003455', 194.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003439', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003382', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003323', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003315', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003005', 89.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003242', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003234', 52.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003218', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003129', 52.99, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003110', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003064', 59.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100303X', 74.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003021', 74.95, 'CAN')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416109', 48.95, 'CAN')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003218', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003129', 25.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003110', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003064', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100303X', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003021', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003234', 25.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002971', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003455', 93.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003005', 43.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003242', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003315', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003323', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003439', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002963', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003463', 53.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003668', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003811', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003986', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861003382', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002750', 43.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416877', 36.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002556', 17.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002580', 55.49, 'GBP')
GO
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002610', 43.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002645', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002653', 21.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002688', 21.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002696', 43.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('186100270X', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002564', 21.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002726', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002947', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002777', 43.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002785', 43.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002807', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002815', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002858', 35.95, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002874', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002882', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002904', 28.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002939', 35.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1861002718', 21.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416656', 22.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416478', 41.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416486', 41.99, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416494', 41.49, 'GBP')
INSERT INTO bookprices (ISBN, Price, Currency) VALUES ('1874416508', 27.99, 'GBP')