authors.sql

来自「这个是我老师给的关于Java核心技术2的第4章的源代码」· 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