authors.sql

来自「Java核心技术卷2 配套源代码 绝对全和经典」· 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