ご自由にご利用ください。country_id
は1にしています:
INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (1,'Alabama','AL',1,990); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (2,'Alaska','AK',1,980); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (3,'Arizona','AZ',1,970); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (4,'Arkansas','AR',1,960); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (5,'California','CA',1,950); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (6,'Colorado','CO',1,940); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (7,'Connecticut','CT',1,930); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (8,'Delaware','DE',1,920); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (9,'Florida','FL',1,910); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (10,'Georgia','GA',1,900); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (11,'Hawaii','HI',1,890); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (12,'Idaho','ID',1,880); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (13,'Illinois','IL',1,870); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (14,'Indiana','IN',1,860); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (15,'Iowa','IA',1,850); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (16,'Kansas','KS',1,840); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (17,'Kentucky','KY',1,830); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (18,'Louisiana','LA',1,820); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (19,'Maine','ME',1,810); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (20,'Maryland','MD',1,800); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (21,'Massachusetts','MA',1,790); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (22,'Michigan','MI',1,780); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (23,'Minnesota','MN',1,770); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (24,'Mississippi','MS',1,760); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (25,'Missouri','MO',1,750); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (26,'Montana','MT',1,740); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (27,'Nebraska','NE',1,730); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (28,'Nevada','NV',1,720); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (29,'New Hampshire','NH',1,710); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (30,'New Jersey','NJ',1,700); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (31,'New Mexico','NM',1,690); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (32,'New York','NY',1,680); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (33,'North Carolina','NC',1,670); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (34,'North Dakota','ND',1,660); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (35,'Ohio','OH',1,650); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (36,'Oklahoma','OK',1,640); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (37,'Oregon','OR',1,630); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (38,'Pennsylvania','PA',1,620); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (39,'Rhode Island','RI',1,610); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (40,'South Carolina','SC',1,600); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (41,'South Dakota','SD',1,590); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (42,'Tennessee','TN',1,580); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (43,'Texas','TX',1,570); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (44,'Utah','UT',1,560); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (45,'Vermont','VT',1,550); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (46,'Virginia','VA',1,540); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (47,'Washington','WA',1,530); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (48,'West Virginia','WV',1,520); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (49,'Wisconsin','WI',1,510); INSERT INTO states (id, name, abbrev, country_id,display_order) VALUES (50,'Wyoming','WY',1,500);