authors.sql

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

CREATE TABLE Authors (Author_Id CHAR(4), Name CHAR(25), Fname CHAR(25))
INSERT INTO Authors VALUES ('ALEX', 'Alexander', 'Christopher')
INSERT INTO Authors VALUES ('BROO', 'Brooks', 'Frederick P.')
INSERT INTO Authors VALUES ('CORM', 'Cormen', 'Thomas H.')
INSERT INTO Authors VALUES ('DATE', 'Date', 'C. J.')
INSERT INTO Authors VALUES ('DARW', 'Darwen', 'Hugh')
INSERT INTO Authors VALUES ('FEIN', 'Feiner', 'Steven K.')
INSERT INTO Authors VALUES ('FLAN', 'Flanagan', 'David')
INSERT INTO Authors VALUES ('FOLE', 'Foley', 'James D.')
INSERT INTO Authors VALUES ('GAMM', 'Gamma', 'Erich')
INSERT INTO Authors VALUES ('GARF', 'Garfinkel', 'Simson')
INSERT INTO Authors VALUES ('HEIN', 'Hein', 'Trent R.')
INSERT INTO Authors VALUES ('HELM', 'Helm', 'Richard')
INSERT INTO Authors VALUES ('HOPC', 'Hopcroft', 'John E.')
INSERT INTO Authors VALUES ('HUGH', 'Hughes', 'John F.')
INSERT INTO Authors VALUES ('ISHI', 'Ishikawa', 'Sara')
INSERT INTO Authors VALUES ('JOHN', 'Johnson', 'Ralph')
INSERT INTO Authors VALUES ('KAHN', 'Kahn', 'David')
INSERT INTO Authors VALUES ('KERN', 'Kernighan', 'Brian')
INSERT INTO Authors VALUES ('KIDD', 'Kidder', 'Tracy')
INSERT INTO Authors VALUES ('KNUT', 'Knuth', 'Donald E.')
INSERT INTO Authors VALUES ('LEIS', 'Leiserson', 'Charles E.')
INSERT INTO Authors VALUES ('MOTW', 'Motwani', 'Rajeev')
INSERT INTO Authors VALUES ('NEME', 'Nemeth', 'Evi')
INSERT INTO Authors VALUES ('RAYM', 'Raymond', 'Eric')
INSERT INTO Authors VALUES ('RITC', 'Ritchie', 'Dennis')
INSERT INTO Authors VALUES ('RIVE', 'Rivest', 'Ronald R.')
INSERT INTO Authors VALUES ('SCHN', 'Schneier', 'Bruce')
INSERT INTO Authors VALUES ('SEEB', 'Seebass', 'Scott')
INSERT INTO Authors VALUES ('SILV', 'Silverstein', 'Murray')
INSERT INTO Authors VALUES ('SNYD', 'Snyder', 'Garth')
INSERT INTO Authors VALUES ('STEI', 'Stein', 'Clifford E.')
INSERT INTO Authors VALUES ('STOL', 'Stoll', 'Clifford')
INSERT INTO Authors VALUES ('STRA', 'Strassmann', 'Steven')
INSERT INTO Authors VALUES ('STRO', 'Stroustrup', 'Bjarne')
INSERT INTO Authors VALUES ('ULLM', 'Ullman', 'Jeffrey D.')
INSERT INTO Authors VALUES ('VAND', 'van Dam', 'Andries')
INSERT INTO Authors VALUES ('VLIS', 'Vlissides', 'John')
INSERT INTO Authors VALUES ('WEIS', 'Weise', 'Daniel')
SELECT * FROM Authors