Revision: 8409
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at September 18, 2008 15:50 by simplistik
Initial Code
CREATE TABLE `state` ( `id` tinyint(4) NOT NULL auto_increment, `name` char(50) NOT NULL default '', `abbreviation` char(2) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8; INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('1','Alabama','AL'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('2','Alaska','AK'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('3','Arizona','AZ'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('4','Arkansas','AR'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('5','California','CA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('6','Colorado','CO'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('7','Connecticut','CT'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('8','Delaware','DE'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('9','District of Columbia','DC'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('10','Florida','FL'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('11','Georgia','GA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('12','Hawaii','HI'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('13','Idaho','ID'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('14','Illinois','IL'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('15','Indiana','IN'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('16','Iowa','IA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('17','Kansas','KS'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('18','Kentucky','KY'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('19','Louisiana','LA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('20','Maine','ME'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('21','Maryland','MD'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('22','Massachusetts','MA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('23','Michigan','MI'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('24','Minnesota','MN'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('25','Mississippi','MS'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('26','Missouri','MO'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('27','Montana','MT'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('28','Nebraska','NE'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('29','Nevada','NV'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('30','New Hampshire','NH'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('31','New Jersey','NJ'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('32','New Mexico','NM'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('33','New York','NY'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('34','North Carolina','NC'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('35','North Dakota','ND'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('36','Ohio','OH'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('37','Oklahoma','OK'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('38','Oregon','OR'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('39','Pennsylvania','PA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('40','Rhode Island','RI'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('41','South Carolina','SC'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('42','South Dakota','SD'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('43','Tennessee','TN'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('44','Texas','TX'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('45','Utah','UT'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('46','Vermont','VT'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('47','Virginia','VA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('48','Washington','WA'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('49','West Virginia','WV'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('50','Wisconsin','WI'); INSERT INTO `state` (`id`,`name`,`abbreviation`) VALUES ('51','Wyoming','WY');
Initial URL
Initial Description
Creates a MySQL table with all 50 states + Washington D.C. in alphabetical order.
Initial Title
50 States & Washington D.C.
Initial Tags
mysql
Initial Language
SQL