《head first sql》读书笔记一

# Dump of table boys# ------------------------CREATE TABLE `boys` (  `boy_id` int(11) default NULL,  `boy` varchar(20) default NULL,  `toy_id` int(11) default NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO `boys` (`boy_id`,`boy`,`toy_id`) VALUES ('1','Davey','3');INSERT INTO `boys` (`boy_id`,`boy`,`toy_id`) VALUES ('2','Bobby','5');INSERT INTO `boys` (`boy_id`,`boy`,`toy_id`) VALUES ('3','Beaver','2');INSERT INTO `boys` (`boy_id`,`boy`,`toy_id`) VALUES ('4','Richie','1');INSERT INTO `boys` (`boy_id`,`boy`,`toy_id`) VALUES ('6','Johnny','4');INSERT INTO `boys` (`boy_id`,`boy`,`toy_id`) VALUES ('5','Billy','2');# Dump of table car_table# ------------------------CREATE TABLE `car_table` (  `VIN` varchar(16) default NULL,  `make` varchar(20) default NULL,  `model` varchar(20) default NULL,  `color` varchar(20) default NULL,  `price` decimal(7,2) default NULL,  `year` varchar(4) default NULL,  `car_id` int(11) NOT NULL auto_increment,  PRIMARY KEY  (`car_id`)) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;INSERT INTO `car_table` (`VIN`,`make`,`model`,`color`,`price`,`year`,`car_id`) VALUES (NULL,'Porsche','Boxter','silver','39393939392E3939','1998','1');INSERT INTO `car_table` (`VIN`,`make`,`model`,`color`,`price`,`year`,`car_id`) VALUES (NULL,'Jaguar','XJ',NULL,'39393939392E3939','2000','2');INSERT INTO `car_table` (`VIN`,`make`,`model`,`color`,`price`,`year`,`car_id`) VALUES (NULL,'Cadillac','Escalade','red','39393939392E3939','2002','3');# Dump of table clown_info# ------------------------CREATE TABLE `clown_info` ( `name` varchar(50) default NULL, `last_seen` varchar(50) default NULL, `appearance` varchar(50) default NULL, `activities` varchar(50) default NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO clown_info VALUES ('Elsie', 'Cherry Hill Senior Center', 'F, red hair, green dress, huge feet', 'balloons, little car');INSERT INTO clown_info VALUES ('Pickles', 'Jack Green\'s party', 'M, orange hair, blue suit, huge feet','mime');INSERT INTO clown_info VALUES ('Snuggles' ,'Ball?Mart' ,'F, yellow shirt, baggy red pants', 'horn, umbrella');INSERT INTO clown_info VALUES ('Mr. Hobo' ,'Party for Eric Gray' ,'M, cigar, black hair, tiny hat violin');INSERT INTO clown_info VALUES ('Clarabelle' ,'Belmont Senior Center' ,'F, pink hair, huge flower, blue dress', 'yelling, dancing');INSERT INTO clown_info VALUES ('Scooter', 'Oakland Hospital' ,'M, blue hair, red suit, huge nose', 'balloons'); INSERT INTO clown_info VALUES ('Zippo' ,'Millstone Mall', 'F, orange suit, baggy pants', 'dancing'); INSERT INTO clown_info VALUES ('Babe', 'Earl抯 Autos' ,'F, all pink and sparkly', 'balancing, little car');INSERT INTO clown_info VALUES ('Bonzo' ,'','M, in drag, polka dotted dress', 'singing, dancing');INSERT INTO clown_info VALUES ('Sniffles' ,'Tracy\'s', 'M, green and purple suit, pointy nose','');