authors.sql

来自「关于Java使用的各种小程序,有文件操作」· 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