booksauthors.sql

这个是我老师给的关于Java核心技术2的第4章的源代码

CREATE TABLE BooksAuthors (ISBN CHAR(13), Author_Id CHAR(4), Seq_No INT)
INSERT INTO BooksAuthors VALUES ('0-201-96426-0', 'DATE', 1)
INSERT INTO BooksAuthors VALUES ('0-201-96426-0', 'DARW', 2)
INSERT INTO BooksAuthors VALUES ('0-19-501919-9', 'ALEX', 1)
INSERT INTO BooksAuthors VALUES ('0-19-501919-9', 'ISHI', 2)
INSERT INTO BooksAuthors VALUES ('0-19-501919-9', 'SILV', 3)
INSERT INTO BooksAuthors VALUES ('0-471-11709-9', 'SCHN', 1)
INSERT INTO BooksAuthors VALUES ('0-201-84840-6', 'FOLE', 1)
INSERT INTO BooksAuthors VALUES ('0-201-84840-6', 'VAND', 2)
INSERT INTO BooksAuthors VALUES ('0-201-84840-6', 'FEIN', 3)
INSERT INTO BooksAuthors VALUES ('0-201-84840-6', 'HUGH', 4)
INSERT INTO BooksAuthors VALUES ('0-7434-1146-3', 'STOL', 1)
INSERT INTO BooksAuthors VALUES ('0-201-63361-2', 'GAMM', 1)
INSERT INTO BooksAuthors VALUES ('0-201-63361-2', 'HELM', 2)
INSERT INTO BooksAuthors VALUES ('0-201-63361-2', 'JOHN', 3)
INSERT INTO BooksAuthors VALUES ('0-201-63361-2', 'VLIS', 4)
INSERT INTO BooksAuthors VALUES ('0-262-03293-7', 'CORM', 1)
INSERT INTO BooksAuthors VALUES ('0-262-03293-7', 'LEIS', 2)
INSERT INTO BooksAuthors VALUES ('0-262-03293-7', 'RIVE', 3)
INSERT INTO BooksAuthors VALUES ('0-262-03293-7', 'STEI', 4)
INSERT INTO BooksAuthors VALUES ('0-201-44124-1', 'HOPC', 1)
INSERT INTO BooksAuthors VALUES ('0-201-44124-1', 'ULLM', 2)
INSERT INTO BooksAuthors VALUES ('0-201-44124-1', 'MOTW', 3)
INSERT INTO BooksAuthors VALUES ('0-596-00048-0', 'FLAN', 1)
INSERT INTO BooksAuthors VALUES ('0-201-89683-4', 'KNUT', 1)
INSERT INTO BooksAuthors VALUES ('0-201-89684-2', 'KNUT', 1)
INSERT INTO BooksAuthors VALUES ('0-201-89685-0', 'KNUT', 1)
INSERT INTO BooksAuthors VALUES ('0-13-110362-8', 'KERN', 1)
INSERT INTO BooksAuthors VALUES ('0-13-110362-8', 'RITC', 2)
INSERT INTO BooksAuthors VALUES ('0-201-70073-5', 'STRO', 1)
INSERT INTO BooksAuthors VALUES ('0-596-00108-8', 'RAYM', 1)
INSERT INTO BooksAuthors VALUES ('0-684-83130-9', 'KAHN', 1)
INSERT INTO BooksAuthors VALUES ('0-201-83595-9', 'BROO', 1)
INSERT INTO BooksAuthors VALUES ('0-679-60261-5', 'KIDD', 1)
INSERT INTO BooksAuthors VALUES ('1-56884-203-1', 'GARF', 1)
INSERT INTO BooksAuthors VALUES ('1-56884-203-1', 'WEIS', 2)
INSERT INTO BooksAuthors VALUES ('1-56884-203-1', 'STRA', 3)
INSERT INTO BooksAuthors VALUES ('0-13-020601-6', 'NEME', 1)
INSERT INTO BooksAuthors VALUES ('0-13-020601-6', 'SNYD', 2)
INSERT INTO BooksAuthors VALUES ('0-13-020601-6', 'SEEB', 3)
INSERT INTO BooksAuthors VALUES ('0-13-020601-6', 'HEIN', 4)
SELECT * FROM BooksAuthors