This came in the Python groups, and I put one up in the database
group, since I will later have to use Python to access the SQL file,
Uhm... To me, an "SQL file" is a file containing SQL statements. It
is NOT a database.
This is part of an SQL file (it's a backup from a MySQL database)
-=-=-=-=-=-
-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.0.24a-community-max-nt-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO'
*/;
--
-- Create schema bestiaria
--
CREATE DATABASE IF NOT EXISTS bestiaria;
USE bestiaria;
--
-- Definition of table `artlinks`
--
DROP TABLE IF EXISTS `artlinks`;
CREATE TABLE `artlinks` (
`ID` int(11) NOT NULL auto_increment,
`category` enum('archive','artist','zine','reference','news') NOT NULL
default 'archive',
`name` varchar(75) NOT NULL default '',
`URL` varchar(75) NOT NULL default '',
`banner` varchar(75) default NULL,
`width` int(11) default NULL,
`height` int(11) default NULL,
`description` varchar(250) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `artlinks`
--
/*!40000 ALTER TABLE `artlinks` DISABLE KEYS */;
INSERT INTO `artlinks`
(`ID`,`category`,`name`,`URL`,`banner`,`width`,`height`,`description`)
VALUES
(1,'archive','Epilogue','
http://www.epilogue.net/',NULL,NULL,NULL,NULL),
(2,'archive','FurNation','
http://www.furnation.com/','images/furnation.gif',404,44,'"The
Artists\' Image Archive"'),
(3,'archive','Elfwood','
http://www.elfwood.com/',NULL,NULL,NULL,'Reorganized,
subsuming the former <i>Lothlorien</i> and <i>Zone47</i> subsites'),
(5,'archive','The Orlando Furry
Archives','
http://fanarchive.net/',NULL,NULL,NULL,NULL),
(6,'archive','Side 7','
http://www.side7.com/',NULL,NULL,NULL,'"the
Artist\'s Archive"'),
(7,'archive','VCL','
http://us.vclart.net/vcl/Artists/',NULL,NULL,NULL,'Furry
Image Archives'),
(37,'archive','Deviant
Art','
http://www.deviantart.com/',NULL,NULL,NULL,'An online artist
collective and marketplace. Various genres.'),
(8,'archive','YERF Archives on
ArtSpots','
http://yerf.artspots.com/',NULL,NULL,NULL,'Formerly known as
<i>The Squeeky Clean Furry Archives</I>. YERF.com has shutdown and
ArtSpots is archiving the directories of those artists wanting them
preserved.'),
(9,'zine','Herd
Mentality','
http://www.furry.org.au/aatheus/herdmentality/',NULL,NULL,NULL,'"The
Centaur Fanzine!" (although the definition of "centaur"
is rather loose)'),
(10,'zine','Huzzah','
http://www.huzzah.com/',NULL,NULL,NULL,'"Anthropomorphics
for Artists"'),
(11,'zine','Sofawolf
Press','
http://www.sofawolf.com/','images/swplogo.gif',158,62,'Sofawolf
Press showcases quality furry fiction in book and magazine format.'),
(12,'artist','Theresa Larsson: Aspects of
Art','
http://www.theresalarsson.se/','images/aspects_of_art.jpg',468,60,NULL),
(13,'artist','Megan
Giles','
http://www.furnation.com/Megan_giles/','images/mgiles.jpg',468,80,NULL),
(14,'artist','MorganKeith
Studios','
http://www.morgankeithstudios.com/',NULL,NULL,NULL,'"MorganKeith
Studios is geared to provide high quality art for print, web and
multimedia as well as practical models, maquettes, prototypes and
concepts." (from their website)'),
(15,'artist','Anna-Karin
Larsson','
http://www.twospotz.com/','images/twospotz.jpg',468,60,NULL),
(16,'artist','White Pony
Productions','
http://www.whiteponyproductions.com/',NULL,NULL,NULL,'Formerly
known as <i>Beth Productions</i>.'),
(17,'artist','Kyoht.com','
http://www.kyoht.com/','images/kyoht1.jpg',400,80,NULL),
(18,'artist','Mitternachts
Lair','
http://www.mitty-art.com/',NULL,NULL,NULL,NULL),
(19,'artist','Sidian.net','
http://www.sidian.net/','images/sidian_banner.jpg',351,89,NULL),
(20,'artist','Eric "Coyote"
Elliott','
http://www.templeofluna.com/ee/',NULL,NULL,NULL,NULL),
(21,'artist','Dark
Natasha','
http://www.darknatasha.com/','images/icon2.jpg',300,114,NULL),
(22,'artist','Synnabar (Stephanie M.
Hahn)','
http://synnabar.critter.net/',NULL,NULL,NULL,NULL),
(23,'artist','Huskie','
http://www.fanarchive.net/Artists/Huskie/',NULL,NULL,NULL,NULL),
(24,'artist','Featherdust
Studios','
http://featherdust.critter.net/',NULL,NULL,NULL,NULL),
(25,'artist','Caribou
Ink','
http://www.redpanda.com/default.asp',NULL,NULL,NULL,NULL),
(26,'artist','Kemono
Inukai','
http://www.kemonet.com/','images/kemonet_m.gif',200,40,NULL),
(27,'artist','SummerDragoness.com (Hannah
Spute)','
http://www.summerdragoness.com/','images/summer_fly.jpg',312,80,NULL),
(28,'artist','Foxprints.com','
http://www.foxprints.com/',NULL,NULL,NULL,'Hosting
Tracy Butler, Candy Palmer, and Cynthia Rowen'),
(29,'artist','JC Amberlyn (aka
DesertCoyote)','
http://www.jcamberlyn.com/',NULL,NULL,NULL,NULL),
(30,'artist','Becky\'s Wildlife & Fantasy
Art','
http://www.wildlife-fantasy.com/',NULL,NULL,NULL,NULL),
(31,'artist','Tracy
Reynolds','
http://www.calicougar.com/',NULL,NULL,NULL,NULL),
(32,'artist','Toonaplooza!','
http://www.toonapalooza.net/','images/button_sheep.jpg',170,50,NULL),
(33,'artist','GoldenWolfen (Christy
Grandjean)','
http://www.goldenwolfen.com/','images/direbanner.jpg',400,80,NULL),
(35,'artist','Nethersphere (Stephanie D.
Lostimolo)','
http://www.nethersphere.com/',NULL,NULL,NULL,NULL),
(36,'artist','Michael
Whelan','
http://www.michaelwhelan.com/',NULL,NULL,NULL,NULL),
(38,'archive','furtopia.org','
http://www.furtopia.org/artwork/artwork.shtml',NULL,NULL,NULL,'Art,
literature, music, and discussion forums'),
(39,'reference','Furry Is...','b_furryis.html',NULL,NULL,NULL,'An essay
by Chuck Melville'),
(40,'reference','The State of Furry','b_stateof.html',NULL,NULL,NULL,'A
1996 Usenet article by Chuck Melville'),
(41,'reference','WikiFur','
http://furry.wikicities.com/wiki/WikiFur_Furry_Central',NULL,NULL,NULL,'Furry
specific wiki-type encyclopedia'),
(42,'reference','Wikipedia','
http://en.wikipedia.org/wiki/Main_Page',NULL,NULL,NULL,'General
wiki-type encyclopedia'),
(43,'news','Flayrah.com','
http://www.flayrah.com/',NULL,NULL,NULL,'In
their words: \"Unusually Good Information\"'),
(44,'news','Dutch
Furs','
http://www.dutchfurs.com/',NULL,NULL,NULL,'News, art, and more...
with a Dutch perspective'),
(45,'archive','FurAffinity','
http://www.furaffinity.net/',NULL,NULL,NULL,'Art,
Stories, Poetry, and Music'),
(46,'reference','A Defense of Furry
Fandom','b_defense.html',NULL,NULL,NULL,'A 2006 essay by \'Coyoty\' Dave
Wright'),
(47,'reference','What are you guys actually fans of,
though?','b_fans_of.html',NULL,NULL,NULL,'A 2006 essay by \'Coyoty\'
Dave Wright'),
(48,'archive','ArtSpots','
http://www.artspots.com/','images/artspots-logo.jpg',361,125,NULL),
(49,'archive','Furry Art
Pile','
http://www.furryartpile.com',NULL,NULL,NULL,'"an art
community for <b>furry artists</b> and <b>connoisseurs</b>."');
/*!40000 ALTER TABLE `artlinks` ENABLE KEYS */;
-=-=-=-=-=-=-
SQL is a nearly standardized language used to make queries into a
database; the language maps fairly closely to the structures used by
most relational database engines, but a relational database is not a
requirement (though I pity the person that has to write an SQL frontend
for an old hierarchical database engine).
What is meant by this statement?
About 90% of the junk for sale spam that shows up in
comp.lang.python is posted by people using gmail accounts. As a result,
my newsreader is configured to not download messages in the group if the
"from" address contains gmail. When seeing a something potentially
interesting quoted by some other responder, I can use the "references"
headers to instruct my news reader to retrieve specific messages -- such
retrieval bypasses the kill filter.
I'm making an effort to see if I can get gmane to pick up messages
that are otherwise killed... Not sure how effective that is. It found
this (your) message, but that's only because I had it fetch the most
recent 50 headers -- not part of the normal "get new" run.
So in short of the responses given, I need to study further: GROUP BY,
HAVING, AS, COUNT, and subselect queries, right?
Since it's homework, we (this group) won't be giving direct SQL
statements...
The relational algebra, I am able to translate it into SQL, or most of
.... and formal relational algebra is a notation many users of database
engines like MySQL, SQLite, Access/JET, Visual FoxPro, Paradox, Sybase,
etc. have never encountered -- heck, Access tries to hide SQL from the
user via a form of QBE interface.
If I were to attempt a textual version of relational algebra, you'd
be getting something on the order of:
t1 = Ships x Classes
t2 = restrict t1(Ships.class = Classes.class)
res = project t2(Ships.name, Classes.class, Classes.country)
instead of straight forward SQL
select Ships.name, Classes.class, Classes.country from Ships
inner join Classes
on Ships.class = Classes.class
--
Wulfraed Dennis Lee Bieber KD6MOG
(e-mail address removed) (e-mail address removed)
HTTP://wlfraed.home.netcom.com/
(Bestiaria Support Staff: (e-mail address removed))
HTTP://www.bestiaria.com/