authors.sql

core java第二卷源代码第四章。欢迎大家下载

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