deyou
43 lines
2.5 KiB
SQL
43 lines
2.5 KiB
SQL
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;
|