authors.sql

来自「java 核心技术 第七版 源码 学习 J2SE」· SQL 代码 · 共 41 行

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