insert1.sql

python web programming 部分

INSERT INTO Author (AutNo, AutFirst, AutLast, AutLoc)
        VALUES (1, 'David', 'Beazley', 'USA');
INSERT INTO Author (AutNo, AutFirst, AutLast, AutLoc)
        VALUES (2, 'Steve', 'Holden', 'USA');
INSERT INTO Author (AutNo, AutFirst, AutLast, AutLoc)
        VALUES (3, 'Mark', 'Lutz', 'USA');
INSERT INTO Author (AutNo, AutFirst, AutLast, AutLoc)
        VALUES (4, 'David', 'Ascher', 'USA');
INSERT INTO Author (AutNo, AutFirst, AutLast, AutLoc)
        VALUES (5, 'Mark', 'Hammond', 'Australia');
INSERT INTO Author (AutNo, AutFirst, AutLast, AutLoc)
        VALUES (6, 'Andy', 'Robinson', 'UK');

INSERT INTO Publisher (PubNo, PubName, PubWebSite)
        VALUES (1, 'New Riders', 'www.newriders.com');
INSERT INTO Publisher (PubNo, PubName, PubWebSite)
        VALUES (2, 'O''Reilly', 'www.ora.com');

INSERT INTO Book (BkISBN, BkName, PubNo, BkYear)
        VALUES ('000000000001', 'Python Essential Reference', 1, 2001);
INSERT INTO Book (BkISBN, BkName, PubNo, BkYear)
        VALUES ('000000000002', 'Web Programming in Python', 1, 2001);
INSERT INTO Book (BkISBN, BkName, PubNo, BkYear)
        VALUES ('000000000003', 'Learning Python', 2, 1999);
INSERT INTO Book (BkISBN, BkName, PubNo, BkYear)
        VALUES ('000000000004', 'Programming Win32 on Python', 2, 1999);

INSERT INTO Authorship (AutNo, BkISBN) VALUES(1, '000000000001');
INSERT INTO Authorship (AutNo, BkISBN) VALUES(2, '000000000002');
INSERT INTO Authorship (AutNo, BkISBN) VALUES(3, '000000000003');
INSERT INTO Authorship (AutNo, BkISBN) VALUES(4, '000000000003');
INSERT INTO Authorship (AutNo, BkISBN) VALUES(5, '000000000004');
INSERT INTO Authorship (AutNo, BkISBN) VALUES(6, '000000000004');