authors.sql

来自「corejava的源程序内有好多的源代码」· 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