authors.sql

来自「java核心技术源代码」· SQL 代码 · 共 57 行

CREATE TABLE Authors (Author_Id CHAR(4), Name CHAR(25), URL CHAR(80))
INSERT INTO Authors VALUES ('ARON', 'Aronson, Larry', 'www.interport.net/~laronson/Homepage.html')
INSERT INTO Authors VALUES ('ARPA', 'Arpajian, Scott', '')
INSERT INTO Authors VALUES ('BEBA', 'Bebak, Arthur', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-645-2')
INSERT INTO Authors VALUES ('BRAN', 'Brandon, Bill', '')
INSERT INTO Authors VALUES ('BROW', 'Brown, Mark', '')
INSERT INTO Authors VALUES ('CAST', 'Castro, Elizabeth', 'www.peachpit.com/peachpit/meetus/authors/elizabeth.castro.html')
INSERT INTO Authors VALUES ('CEAR', 'Cearly, Kent', '')
INSERT INTO Authors VALUES ('CHIN', 'Chin, Francis', '')
INSERT INTO Authors VALUES ('CHU1', 'Chu, Kenny', '')
INSERT INTO Authors VALUES ('DOWN', 'Downing, Troy', 'found.cs.nyu.edu/downing/index.html')
INSERT INTO Authors VALUES ('DUNT', 'Duntemann, Jeff', '')
INSERT INTO Authors VALUES ('EWRI', 'Erwin, Mike', '')
INSERT INTO Authors VALUES ('EVAN', 'Evans, Tim', '')
INSERT INTO Authors VALUES ('FOUS', 'Foust, Jeff', '')
INSERT INTO Authors VALUES ('FOX1', 'Fox, David', 'found.cs.nyu.edu/dfox/index.html')
INSERT INTO Authors VALUES ('GAIT', 'Gaither, Mark', '')
INSERT INTO Authors VALUES ('GRAH', 'Graham, Ian', 'www.utirc.utoronto.ca/personnel/i_graham.html')
INSERT INTO Authors VALUES ('GROV', 'Groves, Dawn', 'www.skycat.com/~dawng/dawn.html')
INSERT INTO Authors VALUES ('HARR', 'Harris, Stuart', 'www.esnet.com/~sirrah/www/')
INSERT INTO Authors VALUES ('HASS', 'Hassinger, Sebastian', '')
INSERT INTO Authors VALUES ('JAME', 'James, Steve', 'www.lanw.com/sjbio.htm')
INSERT INTO Authors VALUES ('JUNG', 'Jung, John', '')
INSERT INTO Authors VALUES ('KARP', 'Karpinski, Richard', '')
INSERT INTO Authors VALUES ('KENN', 'Kennedy, Bill', 'www.ora.com/www/item/html.author.html')
INSERT INTO Authors VALUES ('KERV', 'Kerven, David', '')
INSERT INTO Authors VALUES ('KIDD', 'Kidder, Gayle', 'w3.thegroup.net/~zoom/author.html')
INSERT INTO Authors VALUES ('KNAU', 'Knauss, Greg', '')
INSERT INTO Authors VALUES ('KRCM', 'Krcma, Marianne', '')
INSERT INTO Authors VALUES ('LEJE', 'LeJeune, Urban', 'www.charm.net/~lejeune/')
INSERT INTO Authors VALUES ('LEMA', 'Lemay, Laura', 'slack.lne.com/lemay/index.html')
INSERT INTO Authors VALUES ('MEGA', 'Megan, Robert', '')
INSERT INTO Authors VALUES ('MOR1', 'Morris, Bruce', '')
INSERT INTO Authors VALUES ('MOR2', 'Morris, Mary', '')
INSERT INTO Authors VALUES ('MUL1', 'Mullen, Robert', '')
INSERT INTO Authors VALUES ('MUL2', 'Muller, Nathan', 'www.ddx.com/authtoc.html')
INSERT INTO Authors VALUES ('MUSC', 'Musciano, Chuck', 'www.ora.com/www/item/html.author.html')
INSERT INTO Authors VALUES ('NEOU', 'Neou, Vivian', '')
INSERT INTO Authors VALUES ('PARK', 'Parker, Elisabeth', '')
INSERT INTO Authors VALUES ('POWE', 'Powell, James', 'scholar.lib.vt.edu/jpowell/')
INSERT INTO Authors VALUES ('RAND', 'Randall, Neil', 'randall.uwaterloo.ca/')
INSERT INTO Authors VALUES ('RAY1', 'Ray, Deborah', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-990-7')
INSERT INTO Authors VALUES ('RAY2', 'Ray, Eric', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-990-7')
INSERT INTO Authors VALUES ('READ', 'Ready, Kevin', 'www.browserbydesign.com/book/main/about.htm')
INSERT INTO Authors VALUES ('RECK', 'Recker, Mimi', '')
INSERT INTO Authors VALUES ('SAVO', 'Savola, Tom', '')
INSERT INTO Authors VALUES ('SCHA', 'Scharf, Dean', '')
INSERT INTO Authors VALUES ('SCHE', 'Schengili, Keith', '')
INSERT INTO Authors VALUES ('SMIT', 'Smith, Bud', 'db.www.idgbooks.com/database/book/isbn/about-author.tmpl?query=1-56884-645-2')
INSERT INTO Authors VALUES ('SOSI', 'Sosinsky, Barrie', '')
INSERT INTO Authors VALUES ('STAU', 'Stauffer, Todd', '')
INSERT INTO Authors VALUES ('TAYL', 'Taylor, Dave', 'www.intuitive.com:80/taylor/')
INSERT INTO Authors VALUES ('TITT', 'Tittel, Ed', 'www.lanw.com/etbio.htm')
INSERT INTO Authors VALUES ('WARN', 'Warner, Janine', 'www.browserbydesign.com/book/main/about.htm')
INSERT INTO Authors VALUES ('ZAKO', 'Zakour, John', '')
SELECT * FROM Authors