Posts

Showing posts from 2009

SQL For Creating States, Provinces, Districts, and Territories

INSERT INTO `state` (`state_id`, `abbr`, `name`) VALUES (1,'AL','Alabama'), (2,'AK','Alaska'), (3,'AB','Alberta'), (4,'AZ','Arizona'), (5,'AR','Arkansas'), (6,'BC','British Columbia'), (7,'CA','California'), (8,'CO','Colorado'), (9,'CT','Connecticut'), (10,'DE','Delaware'), (11,'DC','District of Columbia'), (12,'FL','Florida'), (13,'GA','Georgia'), (14,'HI','Hawaii'), (15,'ID','Idaho'), (16,'IL','Illinois'), (17,'IN','Indiana'), (18,'IA','Iowa'), (19,'KS','Kansas'), (20,'KY','Kentucky'), (21,'LB','Labrador'), (22,'LA','Louisiana'), (23,'ME','Maine'), (24,'MB','Mani