Add state/region(s) for Mexico in Magento

If you need to add the states or regions of Mexico to you magento store use the following SQL script.



INSERT INTO `directory_country_region` VALUES (NULL , "MX", "AGS","Aguascalientes"),(NULL , "MX", "BCN","Baja California Norte"),(NULL , "MX", "BCS","Baja California Sur"),(NULL , "MX", "CAM","Campeche"),(NULL , "MX", "CHIS","Chiapas"),(NULL , "MX", "CHIH","Chihuahua"),(NULL , "MX", "COAH","Coahuila"),(NULL , "MX", "COL","Colima"),(NULL , "MX", "DF","Distrito Federal"),(NULL , "MX", "DGO","Durango"),(NULL , "MX", "GTO","Guanajuato"),(NULL , "MX", "GRO","Guerrero"),(NULL , "MX", "HGO","Hidalgo"),(NULL , "MX", "JAL","Jalisco"),(NULL , "MX", "MICH","Michoacan"),(NULL , "MX", "MOR","Morelos"),(NULL , "MX", "MEX","Mexico (Estado de)"),(NULL , "MX", "NAY","Nayarit"),(NULL , "MX", "NL","Nuevo Leon"),(NULL , "MX", "OAX","Oaxaca"),(NULL , "MX", "PUE","Puebla"),(NULL , "MX", "QRO","Queretaro"),(NULL , "MX", "QROO","Quintana Roo"),(NULL , "MX", "SLP","San Luis Potosi"),(NULL , "MX", "SIN","Sinaloa"),(NULL , "MX", "SON","Sonora"),(NULL , "MX", "TAB","Tabasco"),(NULL , "MX", "TAMPS","Tamaulipas"),(NULL , "MX", "TLAX","Tlaxcala"),(NULL , "MX", "VER","Veracruz"),(NULL , "MX", "YUC","Yucatan"),(NULL , "MX", "ZAC","Zacatecas");