Skip to content

Instantly share code, notes, and snippets.

@angeldelrio
Created August 26, 2015 17:25
Show Gist options
  • Star 28 You must be signed in to star a gist
  • Fork 15 You must be signed in to fork a gist
  • Save angeldelrio/1fbf4d54cd62b30fa68c to your computer and use it in GitHub Desktop.
Save angeldelrio/1fbf4d54cd62b30fa68c to your computer and use it in GitHub Desktop.
Tabla MySQL paises el mundo en español
CREATE TABLE `paises` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`iso` char(2) DEFAULT NULL,
`nombre` varchar(80) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
INSERT INTO `paises` VALUES(1, 'AF', 'Afganistán');
INSERT INTO `paises` VALUES(2, 'AX', 'Islas Gland');
INSERT INTO `paises` VALUES(3, 'AL', 'Albania');
INSERT INTO `paises` VALUES(4, 'DE', 'Alemania');
INSERT INTO `paises` VALUES(5, 'AD', 'Andorra');
INSERT INTO `paises` VALUES(6, 'AO', 'Angola');
INSERT INTO `paises` VALUES(7, 'AI', 'Anguilla');
INSERT INTO `paises` VALUES(8, 'AQ', 'Antártida');
INSERT INTO `paises` VALUES(9, 'AG', 'Antigua y Barbuda');
INSERT INTO `paises` VALUES(10, 'AN', 'Antillas Holandesas');
INSERT INTO `paises` VALUES(11, 'SA', 'Arabia Saudí');
INSERT INTO `paises` VALUES(12, 'DZ', 'Argelia');
INSERT INTO `paises` VALUES(13, 'AR', 'Argentina');
INSERT INTO `paises` VALUES(14, 'AM', 'Armenia');
INSERT INTO `paises` VALUES(15, 'AW', 'Aruba');
INSERT INTO `paises` VALUES(16, 'AU', 'Australia');
INSERT INTO `paises` VALUES(17, 'AT', 'Austria');
INSERT INTO `paises` VALUES(18, 'AZ', 'Azerbaiyán');
INSERT INTO `paises` VALUES(19, 'BS', 'Bahamas');
INSERT INTO `paises` VALUES(20, 'BH', 'Bahréin');
INSERT INTO `paises` VALUES(21, 'BD', 'Bangladesh');
INSERT INTO `paises` VALUES(22, 'BB', 'Barbados');
INSERT INTO `paises` VALUES(23, 'BY', 'Bielorrusia');
INSERT INTO `paises` VALUES(24, 'BE', 'Bélgica');
INSERT INTO `paises` VALUES(25, 'BZ', 'Belice');
INSERT INTO `paises` VALUES(26, 'BJ', 'Benin');
INSERT INTO `paises` VALUES(27, 'BM', 'Bermudas');
INSERT INTO `paises` VALUES(28, 'BT', 'Bhután');
INSERT INTO `paises` VALUES(29, 'BO', 'Bolivia');
INSERT INTO `paises` VALUES(30, 'BA', 'Bosnia y Herzegovina');
INSERT INTO `paises` VALUES(31, 'BW', 'Botsuana');
INSERT INTO `paises` VALUES(32, 'BV', 'Isla Bouvet');
INSERT INTO `paises` VALUES(33, 'BR', 'Brasil');
INSERT INTO `paises` VALUES(34, 'BN', 'Brunéi');
INSERT INTO `paises` VALUES(35, 'BG', 'Bulgaria');
INSERT INTO `paises` VALUES(36, 'BF', 'Burkina Faso');
INSERT INTO `paises` VALUES(37, 'BI', 'Burundi');
INSERT INTO `paises` VALUES(38, 'CV', 'Cabo Verde');
INSERT INTO `paises` VALUES(39, 'KY', 'Islas Caimán');
INSERT INTO `paises` VALUES(40, 'KH', 'Camboya');
INSERT INTO `paises` VALUES(41, 'CM', 'Camerún');
INSERT INTO `paises` VALUES(42, 'CA', 'Canadá');
INSERT INTO `paises` VALUES(43, 'CF', 'República Centroafricana');
INSERT INTO `paises` VALUES(44, 'TD', 'Chad');
INSERT INTO `paises` VALUES(45, 'CZ', 'República Checa');
INSERT INTO `paises` VALUES(46, 'CL', 'Chile');
INSERT INTO `paises` VALUES(47, 'CN', 'China');
INSERT INTO `paises` VALUES(48, 'CY', 'Chipre');
INSERT INTO `paises` VALUES(49, 'CX', 'Isla de Navidad');
INSERT INTO `paises` VALUES(50, 'VA', 'Ciudad del Vaticano');
INSERT INTO `paises` VALUES(51, 'CC', 'Islas Cocos');
INSERT INTO `paises` VALUES(52, 'CO', 'Colombia');
INSERT INTO `paises` VALUES(53, 'KM', 'Comoras');
INSERT INTO `paises` VALUES(54, 'CD', 'República Democrática del Congo');
INSERT INTO `paises` VALUES(55, 'CG', 'Congo');
INSERT INTO `paises` VALUES(56, 'CK', 'Islas Cook');
INSERT INTO `paises` VALUES(57, 'KP', 'Corea del Norte');
INSERT INTO `paises` VALUES(58, 'KR', 'Corea del Sur');
INSERT INTO `paises` VALUES(59, 'CI', 'Costa de Marfil');
INSERT INTO `paises` VALUES(60, 'CR', 'Costa Rica');
INSERT INTO `paises` VALUES(61, 'HR', 'Croacia');
INSERT INTO `paises` VALUES(62, 'CU', 'Cuba');
INSERT INTO `paises` VALUES(63, 'DK', 'Dinamarca');
INSERT INTO `paises` VALUES(64, 'DM', 'Dominica');
INSERT INTO `paises` VALUES(65, 'DO', 'República Dominicana');
INSERT INTO `paises` VALUES(66, 'EC', 'Ecuador');
INSERT INTO `paises` VALUES(67, 'EG', 'Egipto');
INSERT INTO `paises` VALUES(68, 'SV', 'El Salvador');
INSERT INTO `paises` VALUES(69, 'AE', 'Emiratos Árabes Unidos');
INSERT INTO `paises` VALUES(70, 'ER', 'Eritrea');
INSERT INTO `paises` VALUES(71, 'SK', 'Eslovaquia');
INSERT INTO `paises` VALUES(72, 'SI', 'Eslovenia');
INSERT INTO `paises` VALUES(73, 'ES', 'España');
INSERT INTO `paises` VALUES(74, 'UM', 'Islas ultramarinas de Estados Unidos');
INSERT INTO `paises` VALUES(75, 'US', 'Estados Unidos');
INSERT INTO `paises` VALUES(76, 'EE', 'Estonia');
INSERT INTO `paises` VALUES(77, 'ET', 'Etiopía');
INSERT INTO `paises` VALUES(78, 'FO', 'Islas Feroe');
INSERT INTO `paises` VALUES(79, 'PH', 'Filipinas');
INSERT INTO `paises` VALUES(80, 'FI', 'Finlandia');
INSERT INTO `paises` VALUES(81, 'FJ', 'Fiyi');
INSERT INTO `paises` VALUES(82, 'FR', 'Francia');
INSERT INTO `paises` VALUES(83, 'GA', 'Gabón');
INSERT INTO `paises` VALUES(84, 'GM', 'Gambia');
INSERT INTO `paises` VALUES(85, 'GE', 'Georgia');
INSERT INTO `paises` VALUES(86, 'GS', 'Islas Georgias del Sur y Sandwich del Sur');
INSERT INTO `paises` VALUES(87, 'GH', 'Ghana');
INSERT INTO `paises` VALUES(88, 'GI', 'Gibraltar');
INSERT INTO `paises` VALUES(89, 'GD', 'Granada');
INSERT INTO `paises` VALUES(90, 'GR', 'Grecia');
INSERT INTO `paises` VALUES(91, 'GL', 'Groenlandia');
INSERT INTO `paises` VALUES(92, 'GP', 'Guadalupe');
INSERT INTO `paises` VALUES(93, 'GU', 'Guam');
INSERT INTO `paises` VALUES(94, 'GT', 'Guatemala');
INSERT INTO `paises` VALUES(95, 'GF', 'Guayana Francesa');
INSERT INTO `paises` VALUES(96, 'GN', 'Guinea');
INSERT INTO `paises` VALUES(97, 'GQ', 'Guinea Ecuatorial');
INSERT INTO `paises` VALUES(98, 'GW', 'Guinea-Bissau');
INSERT INTO `paises` VALUES(99, 'GY', 'Guyana');
INSERT INTO `paises` VALUES(100, 'HT', 'Haití');
INSERT INTO `paises` VALUES(101, 'HM', 'Islas Heard y McDonald');
INSERT INTO `paises` VALUES(102, 'HN', 'Honduras');
INSERT INTO `paises` VALUES(103, 'HK', 'Hong Kong');
INSERT INTO `paises` VALUES(104, 'HU', 'Hungría');
INSERT INTO `paises` VALUES(105, 'IN', 'India');
INSERT INTO `paises` VALUES(106, 'ID', 'Indonesia');
INSERT INTO `paises` VALUES(107, 'IR', 'Irán');
INSERT INTO `paises` VALUES(108, 'IQ', 'Iraq');
INSERT INTO `paises` VALUES(109, 'IE', 'Irlanda');
INSERT INTO `paises` VALUES(110, 'IS', 'Islandia');
INSERT INTO `paises` VALUES(111, 'IL', 'Israel');
INSERT INTO `paises` VALUES(112, 'IT', 'Italia');
INSERT INTO `paises` VALUES(113, 'JM', 'Jamaica');
INSERT INTO `paises` VALUES(114, 'JP', 'Japón');
INSERT INTO `paises` VALUES(115, 'JO', 'Jordania');
INSERT INTO `paises` VALUES(116, 'KZ', 'Kazajstán');
INSERT INTO `paises` VALUES(117, 'KE', 'Kenia');
INSERT INTO `paises` VALUES(118, 'KG', 'Kirguistán');
INSERT INTO `paises` VALUES(119, 'KI', 'Kiribati');
INSERT INTO `paises` VALUES(120, 'KW', 'Kuwait');
INSERT INTO `paises` VALUES(121, 'LA', 'Laos');
INSERT INTO `paises` VALUES(122, 'LS', 'Lesotho');
INSERT INTO `paises` VALUES(123, 'LV', 'Letonia');
INSERT INTO `paises` VALUES(124, 'LB', 'Líbano');
INSERT INTO `paises` VALUES(125, 'LR', 'Liberia');
INSERT INTO `paises` VALUES(126, 'LY', 'Libia');
INSERT INTO `paises` VALUES(127, 'LI', 'Liechtenstein');
INSERT INTO `paises` VALUES(128, 'LT', 'Lituania');
INSERT INTO `paises` VALUES(129, 'LU', 'Luxemburgo');
INSERT INTO `paises` VALUES(130, 'MO', 'Macao');
INSERT INTO `paises` VALUES(131, 'MK', 'ARY Macedonia');
INSERT INTO `paises` VALUES(132, 'MG', 'Madagascar');
INSERT INTO `paises` VALUES(133, 'MY', 'Malasia');
INSERT INTO `paises` VALUES(134, 'MW', 'Malawi');
INSERT INTO `paises` VALUES(135, 'MV', 'Maldivas');
INSERT INTO `paises` VALUES(136, 'ML', 'Malí');
INSERT INTO `paises` VALUES(137, 'MT', 'Malta');
INSERT INTO `paises` VALUES(138, 'FK', 'Islas Malvinas');
INSERT INTO `paises` VALUES(139, 'MP', 'Islas Marianas del Norte');
INSERT INTO `paises` VALUES(140, 'MA', 'Marruecos');
INSERT INTO `paises` VALUES(141, 'MH', 'Islas Marshall');
INSERT INTO `paises` VALUES(142, 'MQ', 'Martinica');
INSERT INTO `paises` VALUES(143, 'MU', 'Mauricio');
INSERT INTO `paises` VALUES(144, 'MR', 'Mauritania');
INSERT INTO `paises` VALUES(145, 'YT', 'Mayotte');
INSERT INTO `paises` VALUES(146, 'MX', 'México');
INSERT INTO `paises` VALUES(147, 'FM', 'Micronesia');
INSERT INTO `paises` VALUES(148, 'MD', 'Moldavia');
INSERT INTO `paises` VALUES(149, 'MC', 'Mónaco');
INSERT INTO `paises` VALUES(150, 'MN', 'Mongolia');
INSERT INTO `paises` VALUES(151, 'MS', 'Montserrat');
INSERT INTO `paises` VALUES(152, 'MZ', 'Mozambique');
INSERT INTO `paises` VALUES(153, 'MM', 'Myanmar');
INSERT INTO `paises` VALUES(154, 'NA', 'Namibia');
INSERT INTO `paises` VALUES(155, 'NR', 'Nauru');
INSERT INTO `paises` VALUES(156, 'NP', 'Nepal');
INSERT INTO `paises` VALUES(157, 'NI', 'Nicaragua');
INSERT INTO `paises` VALUES(158, 'NE', 'Níger');
INSERT INTO `paises` VALUES(159, 'NG', 'Nigeria');
INSERT INTO `paises` VALUES(160, 'NU', 'Niue');
INSERT INTO `paises` VALUES(161, 'NF', 'Isla Norfolk');
INSERT INTO `paises` VALUES(162, 'NO', 'Noruega');
INSERT INTO `paises` VALUES(163, 'NC', 'Nueva Caledonia');
INSERT INTO `paises` VALUES(164, 'NZ', 'Nueva Zelanda');
INSERT INTO `paises` VALUES(165, 'OM', 'Omán');
INSERT INTO `paises` VALUES(166, 'NL', 'Países Bajos');
INSERT INTO `paises` VALUES(167, 'PK', 'Pakistán');
INSERT INTO `paises` VALUES(168, 'PW', 'Palau');
INSERT INTO `paises` VALUES(169, 'PS', 'Palestina');
INSERT INTO `paises` VALUES(170, 'PA', 'Panamá');
INSERT INTO `paises` VALUES(171, 'PG', 'Papúa Nueva Guinea');
INSERT INTO `paises` VALUES(172, 'PY', 'Paraguay');
INSERT INTO `paises` VALUES(173, 'PE', 'Perú');
INSERT INTO `paises` VALUES(174, 'PN', 'Islas Pitcairn');
INSERT INTO `paises` VALUES(175, 'PF', 'Polinesia Francesa');
INSERT INTO `paises` VALUES(176, 'PL', 'Polonia');
INSERT INTO `paises` VALUES(177, 'PT', 'Portugal');
INSERT INTO `paises` VALUES(178, 'PR', 'Puerto Rico');
INSERT INTO `paises` VALUES(179, 'QA', 'Qatar');
INSERT INTO `paises` VALUES(180, 'GB', 'Reino Unido');
INSERT INTO `paises` VALUES(181, 'RE', 'Reunión');
INSERT INTO `paises` VALUES(182, 'RW', 'Ruanda');
INSERT INTO `paises` VALUES(183, 'RO', 'Rumania');
INSERT INTO `paises` VALUES(184, 'RU', 'Rusia');
INSERT INTO `paises` VALUES(185, 'EH', 'Sahara Occidental');
INSERT INTO `paises` VALUES(186, 'SB', 'Islas Salomón');
INSERT INTO `paises` VALUES(187, 'WS', 'Samoa');
INSERT INTO `paises` VALUES(188, 'AS', 'Samoa Americana');
INSERT INTO `paises` VALUES(189, 'KN', 'San Cristóbal y Nevis');
INSERT INTO `paises` VALUES(190, 'SM', 'San Marino');
INSERT INTO `paises` VALUES(191, 'PM', 'San Pedro y Miquelón');
INSERT INTO `paises` VALUES(192, 'VC', 'San Vicente y las Granadinas');
INSERT INTO `paises` VALUES(193, 'SH', 'Santa Helena');
INSERT INTO `paises` VALUES(194, 'LC', 'Santa Lucía');
INSERT INTO `paises` VALUES(195, 'ST', 'Santo Tomé y Príncipe');
INSERT INTO `paises` VALUES(196, 'SN', 'Senegal');
INSERT INTO `paises` VALUES(197, 'CS', 'Serbia y Montenegro');
INSERT INTO `paises` VALUES(198, 'SC', 'Seychelles');
INSERT INTO `paises` VALUES(199, 'SL', 'Sierra Leona');
INSERT INTO `paises` VALUES(200, 'SG', 'Singapur');
INSERT INTO `paises` VALUES(201, 'SY', 'Siria');
INSERT INTO `paises` VALUES(202, 'SO', 'Somalia');
INSERT INTO `paises` VALUES(203, 'LK', 'Sri Lanka');
INSERT INTO `paises` VALUES(204, 'SZ', 'Suazilandia');
INSERT INTO `paises` VALUES(205, 'ZA', 'Sudáfrica');
INSERT INTO `paises` VALUES(206, 'SD', 'Sudán');
INSERT INTO `paises` VALUES(207, 'SE', 'Suecia');
INSERT INTO `paises` VALUES(208, 'CH', 'Suiza');
INSERT INTO `paises` VALUES(209, 'SR', 'Surinam');
INSERT INTO `paises` VALUES(210, 'SJ', 'Svalbard y Jan Mayen');
INSERT INTO `paises` VALUES(211, 'TH', 'Tailandia');
INSERT INTO `paises` VALUES(212, 'TW', 'Taiwán');
INSERT INTO `paises` VALUES(213, 'TZ', 'Tanzania');
INSERT INTO `paises` VALUES(214, 'TJ', 'Tayikistán');
INSERT INTO `paises` VALUES(215, 'IO', 'Territorio Británico del Océano Índico');
INSERT INTO `paises` VALUES(216, 'TF', 'Territorios Australes Franceses');
INSERT INTO `paises` VALUES(217, 'TL', 'Timor Oriental');
INSERT INTO `paises` VALUES(218, 'TG', 'Togo');
INSERT INTO `paises` VALUES(219, 'TK', 'Tokelau');
INSERT INTO `paises` VALUES(220, 'TO', 'Tonga');
INSERT INTO `paises` VALUES(221, 'TT', 'Trinidad y Tobago');
INSERT INTO `paises` VALUES(222, 'TN', 'Túnez');
INSERT INTO `paises` VALUES(223, 'TC', 'Islas Turcas y Caicos');
INSERT INTO `paises` VALUES(224, 'TM', 'Turkmenistán');
INSERT INTO `paises` VALUES(225, 'TR', 'Turquía');
INSERT INTO `paises` VALUES(226, 'TV', 'Tuvalu');
INSERT INTO `paises` VALUES(227, 'UA', 'Ucrania');
INSERT INTO `paises` VALUES(228, 'UG', 'Uganda');
INSERT INTO `paises` VALUES(229, 'UY', 'Uruguay');
INSERT INTO `paises` VALUES(230, 'UZ', 'Uzbekistán');
INSERT INTO `paises` VALUES(231, 'VU', 'Vanuatu');
INSERT INTO `paises` VALUES(232, 'VE', 'Venezuela');
INSERT INTO `paises` VALUES(233, 'VN', 'Vietnam');
INSERT INTO `paises` VALUES(234, 'VG', 'Islas Vírgenes Británicas');
INSERT INTO `paises` VALUES(235, 'VI', 'Islas Vírgenes de los Estados Unidos');
INSERT INTO `paises` VALUES(236, 'WF', 'Wallis y Futuna');
INSERT INTO `paises` VALUES(237, 'YE', 'Yemen');
INSERT INTO `paises` VALUES(238, 'DJ', 'Yibuti');
INSERT INTO `paises` VALUES(239, 'ZM', 'Zambia');
INSERT INTO `paises` VALUES(240, 'ZW', 'Zimbabue');
@leunam90
Copy link

Thank you

@JBdesarrollo
Copy link

Thanks bro.

@allberttosanchez
Copy link

thank you.

@angeldelacruzdev
Copy link

Gracias bro!

@efrain2010
Copy link

$countries = [
[
'name' => 'Afganistán'
],
[
'name' => 'Islas Gland'
],
[
'name' => 'Albania'
],
[
'name' => 'Alemania'
],
[
'name' => 'Andorra'
],
[
'name' => 'Angola'
],
[
'name' => 'Anguilla'
],
[
'name' => 'Antártida'
],
[
'name' => 'Antigua y Barbuda'
],
[
'name' => 'Antillas Holandesas'
],
[
'name' => 'Arabia Saudí'
],
[
'name' => 'Argelia'
],
[
'name' => 'Argentina'
],
[
'name' => 'Armenia'
],
[
'name' => 'Aruba'
],
[
'name' => 'Australia'
],
[
'name' => 'Austria'
],
[
'name' => 'Azerbaiyán'
],
[
'name' => 'Bahamas'
],
[
'name' => 'Bahréin'
],
[
'name' => 'Bangladesh'
],
[
'name' => 'Barbados'
],
[
'name' => 'Bielorrusia'
],
[
'name' => 'Bélgica'
],
[
'name' => 'Belice'
],
[
'name' => 'Benin'
],
[
'name' => 'Bermudas'
],
[
'name' => 'Bhután'
],
[
'name' => 'Bolivia'
],
[
'name' => 'Bosnia y Herzegovina'
],
[
'name' => 'Botsuana'
],
[
'name' => 'Isla Bouvet'
],
[
'name' => 'Brasil'
],
[
'name' => 'Brunéi'
],
[
'name' => 'Bulgaria'
],
[
'name' => 'Burkina Faso'
],
[
'name' => 'Burundi'
],
[
'name' => 'Cabo Verde'
],
[
'name' => 'Islas Caimán'
],
[
'name' => 'Camboya'
],
[
'name' => 'Camerún'
],
[
'name' => 'Canadá'
],
[
'name' => 'República Centroafricana'
],
[
'name' => 'Chad'
],
[
'name' => 'República Checa'
],
[
'name' => 'Chile'
],
[
'name' => 'China'
],
[
'name' => 'Chipre'
],
[
'name' => 'Isla de Navidad'
],
[
'name' => 'Ciudad del Vaticano'
],
[
'name' => 'Islas Cocos'
],
[
'name' => 'Colombia'
],
[
'name' => 'Comoras'
],
[
'name' => 'República Democrática del Congo'
],
[
'name' => 'Congo'
],
[
'name' => 'Islas Cook'
],
[
'name' => 'Corea del Norte'
],
[
'name' => 'Corea del Sur'
],
[
'name' => 'Costa de Marfil'
],
[
'name' => 'Costa Rica'
],
[
'name' => 'Croacia'
],
[
'name' => 'Cuba'
],
[
'name' => 'Dinamarca'
],
[
'name' => 'Dominica'
],
[
'name' => 'República Dominicana'
],
[
'name' => 'Ecuador'
],
[
'name' => 'Egipto'
],
[
'name' => 'El Salvador'
],
[
'name' => 'Emiratos Árabes Unidos'
],
[
'name' => 'Eritrea'
],
[
'name' => 'Eslovaquia'
],
[
'name' => 'Eslovenia'
],
[
'name' => 'España'
],
[
'name' => 'Islas ultramarinas de Estados Unidos'
],
[
'name' => 'Estados Unidos'
],
[
'name' => 'Estonia'
],
[
'name' => 'Etiopía'
],
[
'name' => 'Islas Feroe'
],
[
'name' => 'Filipinas'
],
[
'name' => 'Finlandia'
],
[
'name' => 'Fiyi'
],
[
'name' => 'Francia'
],
[
'name' => 'Gabón'
],
[
'name' => 'Gambia'
],
[
'name' => 'Georgia'
],
[
'name' => 'Islas Georgias del Sur y Sandwich del Sur'
],
[
'name' => 'Ghana'
],
[
'name' => 'Gibraltar'
],
[
'name' => 'Granada'
],
[
'name' => 'Grecia'
],
[
'name' => 'Groenlandia'
],
[
'name' => 'Guadalupe'
],
[
'name' => 'Guam'
],
[
'name' => 'Guatemala'
],
[
'name' => 'Guayana Francesa'
],
[
'name' => 'Guinea'
],
[
'name' => 'Guinea Ecuatorial'
],
[
'name' => 'Guinea-Bissau'
],
[
'name' => 'Guyana'
],
[
'name' => 'Haití'
],
[
'name' => 'Islas Heard y McDonald'
],
[
'name' => 'Honduras'
],
[
'name' => 'Hong Kong'
],
[
'name' => 'Hungría'
],
[
'name' => 'India'
],
[
'name' => 'Indonesia'
],
[
'name' => 'Irán'
],
[
'name' => 'Iraq'
],
[
'name' => 'Irlanda'
],
[
'name' => 'Islandia'
],
[
'name' => 'Israel'
],
[
'name' => 'Italia'
],
[
'name' => 'Jamaica'
],
[
'name' => 'Japón'
],
[
'name' => 'Jordania'
],
[
'name' => 'Kazajstán'
],
[
'name' => 'Kenia'
],
[
'name' => 'Kirguistán'
],
[
'name' => 'Kiribati'
],
[
'name' => 'Kuwait'
],
[
'name' => 'Laos'
],
[
'name' => 'Lesotho'
],
[
'name' => 'Letonia'
],
[
'name' => 'Líbano'
],
[
'name' => 'Liberia'
],
[
'name' => 'Libia'
],
[
'name' => 'Liechtenstein'
],
[
'name' => 'Lituania'
],
[
'name' => 'Luxemburgo'
],
[
'name' => 'Macao'
],
[
'name' => 'ARY Macedonia'
],
[
'name' => 'Madagascar'
],
[
'name' => 'Malasia'
],
[
'name' => 'Malawi'
],
[
'name' => 'Maldivas'
],
[
'name' => 'Malí'
],
[
'name' => 'Malta'
],
[
'name' => 'Islas Malvinas'
],
[
'name' => 'Islas Marianas del Norte'
],
[
'name' => 'Marruecos'
],
[
'name' => 'Islas Marshall'
],
[
'name' => 'Martinica'
],
[
'name' => 'Mauricio'
],
[
'name' => 'Mauritania'
],
[
'name' => 'Mayotte'
],
[
'name' => 'México'
],
[
'name' => 'Micronesia'
],
[
'name' => 'Moldavia'
],
[
'name' => 'Mónaco'
],
[
'name' => 'Mongolia'
],
[
'name' => 'Montserrat'
],
[
'name' => 'Mozambique'
],
[
'name' => 'Myanmar'
],
[
'name' => 'Namibia'
],
[
'name' => 'Nauru'
],
[
'name' => 'Nepal'
],
[
'name' => 'Nicaragua'
],
[
'name' => 'Níger'
],
[
'name' => 'Nigeria'
],
[
'name' => 'Niue'
],
[
'name' => 'Isla Norfolk'
],
[
'name' => 'Noruega'
],
[
'name' => 'Nueva Caledonia'
],
[
'name' => 'Nueva Zelanda'
],
[
'name' => 'Omán'
],
[
'name' => 'Países Bajos'
],
[
'name' => 'Pakistán'
],
[
'name' => 'Palau'
],
[
'name' => 'Palestina'
],
[
'name' => 'Panamá'
],
[
'name' => 'Papúa Nueva Guinea'
],
[
'name' => 'Paraguay'
],
[
'name' => 'Perú'
],
[
'name' => 'Islas Pitcairn'
],
[
'name' => 'Polinesia Francesa'
],
[
'name' => 'Polonia'
],
[
'name' => 'Portugal'
],
[
'name' => 'Puerto Rico'
],
[
'name' => 'Qatar'
],
[
'name' => 'Reino Unido'
],
[
'name' => 'Reunión'
],
[
'name' => 'Ruanda'
],
[
'name' => 'Rumania'
],
[
'name' => 'Rusia'
],
[
'name' => 'Sahara Occidental'
],
[
'name' => 'Islas Salomón'
],
[
'name' => 'Samoa'
],
[
'name' => 'Samoa Americana'
],
[
'name' => 'San Cristóbal y Nevis'
],
[
'name' => 'San Marino'
],
[
'name' => 'San Pedro y Miquelón'
],
[
'name' => 'San Vicente y las Granadinas'
],
[
'name' => 'Santa Helena'
],
[
'name' => 'Santa Lucía'
],
[
'name' => 'Santo Tomé y Príncipe'
],
[
'name' => 'Senegal'
],
[
'name' => 'Serbia y Montenegro'
],
[
'name' => 'Seychelles'
],
[
'name' => 'Sierra Leona'
],
[
'name' => 'Singapur'
],
[
'name' => 'Siria'
],
[
'name' => 'Somalia'
],
[
'name' => 'Sri Lanka'
],
[
'name' => 'Suazilandia'
],
[
'name' => 'Sudáfrica'
],
[
'name' => 'Sudán'
],
[
'name' => 'Suecia'
],
[
'name' => 'Suiza'
],
[
'name' => 'Surinam'
],
[
'name' => 'Svalbard y Jan Mayen'
],
[
'name' => 'Tailandia'
],
[
'name' => 'Taiwán'
],
[
'name' => 'Tanzania'
],
[
'name' => 'Tayikistán'
],
[
'name' => 'Territorio Británico del Océano Índico'
],
[
'name' => 'Territorios Australes Franceses'
],
[
'name' => 'Timor Oriental'
],
[
'name' => 'Togo'
],
[
'name' => 'Tokelau'
],
[
'name' => 'Tonga'
],
[
'name' => 'Trinidad y Tobago'
],
[
'name' => 'Túnez'
],
[
'name' => 'Islas Turcas y Caicos'
],
[
'name' => 'Turkmenistán'
],
[
'name' => 'Turquía'
],
[
'name' => 'Tuvalu'
],
[
'name' => 'Ucrania'
],
[
'name' => 'Uganda'
],
[
'name' => 'Uruguay'
],
[
'name' => 'Uzbekistán'
],
[
'name' => 'Vanuatu'
],
[
'name' => 'Venezuela'
],
[
'name' => 'Vietnam'
],
[
'name' => 'Islas Vírgenes Británicas'
],
[
'name' => 'Islas Vírgenes de los Estados Unidos'
],
[
'name' => 'Wallis y Futuna'
],
[
'name' => 'Yemen'
],
[
'name' => 'Yibuti'
],
[
'name' => 'Zambia'
],
[
'name' => 'Zimbabue'
]
];

@efrain2010
Copy link

$mexico_id = 146;

$mexicoEstados = [
[
'name' => 'Aguascalientes',
'country_id' => $mexico_id
],
[
'name' => 'Baja California',
'country_id' => $mexico_id
],
[
'name' => 'Baja California Sur',
'country_id' => $mexico_id
],
[
'name' => 'Campeche',
'country_id' => $mexico_id
],
[
'name' => 'Coahuila de Zaragoza',
'country_id' => $mexico_id
],
[
'name' => 'Colima',
'country_id' => $mexico_id
],
[
'name' => 'Chiapas',
'country_id' => $mexico_id
],
[
'name' => 'Chihuahua',
'country_id' => $mexico_id
],
[
'name' => 'Distrito Federal',
'country_id' => $mexico_id
],
[
'name' => 'Durango',
'country_id' => $mexico_id
],
[
'name' => 'Guanajuato',
'country_id' => $mexico_id
],
[
'name' => 'Guerrero',
'country_id' => $mexico_id
],
[
'name' => 'Hidalgo',
'country_id' => $mexico_id
],
[
'name' => 'Jalisco',
'country_id' => $mexico_id
],
[
'name' => 'México',
'country_id' => $mexico_id
],
[
'name' => 'Michoacán de Ocampo',
'country_id' => $mexico_id
],
[
'name' => 'Morelos',
'country_id' => $mexico_id
],
[
'name' => 'Nayarit',
'country_id' => $mexico_id
],
[
'name' => 'Nuevo León',
'country_id' => $mexico_id
],
[
'name' => 'Oaxaca de Juárez',
'country_id' => $mexico_id
],
[
'name' => 'Puebla',
'country_id' => $mexico_id
],
[
'name' => 'Querétaro',
'country_id' => $mexico_id
],
[
'name' => 'Qana Roo',
'country_id' => $mexico_id
],
[
'name' => 'San Luis Potosí',
'country_id' => $mexico_id
],
[
'name' => 'Sinaloa',
'country_id' => $mexico_id
],
[
'name' => 'Sonora',
'country_id' => $mexico_id
],
[
'name' => 'Tabasco',
'country_id' => $mexico_id
],
[
'name' => 'Tamaulipas',
'country_id' => $mexico_id
],
[
'name' => 'Tlaxcala',
'country_id' => $mexico_id
],
[
'name' => 'Veracruz de Ignacio de la Llave',
'country_id' => $mexico_id
],
[
'name' => 'Yucatán',
'country_id' => $mexico_id
],
[
'name' => 'Zacatecas',
'country_id' => $mexico_id
]
];

@simcos7
Copy link

simcos7 commented Aug 30, 2019

INSERT INTO paises VALUES(241, 'CW', 'Curazao');

@gilberto9312
Copy link

thank you

@emma893
Copy link

emma893 commented Apr 13, 2020

Thank you!

@Reynaldo-byte
Copy link

Thank you!

@abelmiraval
Copy link

abelmiraval commented Oct 9, 2020

LARAVEL

`<?php

use App\Country;
use Illuminate\Database\Seeder;
use PHPUnit\Framework\Constraint\Count;

class CountrySeeder extends Seeder
{
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$countries = array(

        array('id' => 1,  'short_description' => 'AF', 'long_description' => 'Afganistán'),
        array('id' => 2,  'short_description' => 'AX', 'long_description' => 'Islas Gland'),
        array('id' => 3,  'short_description' => 'AL', 'long_description' => 'Albania'),
        array('id' => 4,  'short_description' => 'DE', 'long_description' => 'Alemania'),
        array('id' => 5,  'short_description' => 'AD', 'long_description' => 'Andorra'),
        array('id' => 6,  'short_description' => 'AO', 'long_description' => 'Angola'),
        array('id' => 7,  'short_description' => 'AI', 'long_description' => 'Anguilla'),
        array('id' => 8,  'short_description' => 'AQ', 'long_description' => 'Antártida'),
        array('id' => 9,  'short_description' => 'AG', 'long_description' => 'Antigua y Barbuda'),
        array('id' => 10, 'short_description' => 'AN', 'long_description' =>  'Antillas Holandesas'),
        array('id' => 11, 'short_description' => 'SA', 'long_description' =>  'Arabia Saudí'),
        array('id' => 12, 'short_description' => 'DZ', 'long_description' =>  'Argelia'),
        array('id' => 13, 'short_description' => 'AR', 'long_description' =>  'Argentina'),
        array('id' => 14, 'short_description' => 'AM', 'long_description' =>  'Armenia'),
        array('id' => 15, 'short_description' => 'AW', 'long_description' =>  'Aruba'),
        array('id' => 16, 'short_description' => 'AU', 'long_description' =>  'Australia'),
        array('id' => 17, 'short_description' => 'AT', 'long_description' =>  'Austria'),
        array('id' => 18, 'short_description' => 'AZ', 'long_description' =>  'Azerbaiyán'),
        array('id' => 19, 'short_description' => 'BS', 'long_description' =>  'Bahamas'),
        array('id' => 20, 'short_description' => 'BH', 'long_description' =>  'Bahréin'),
        array('id' => 21, 'short_description' => 'BD', 'long_description' =>  'Bangladesh'),
        array('id' => 22, 'short_description' => 'BB', 'long_description' =>  'Barbados'),
        array('id' => 23, 'short_description' => 'BY', 'long_description' =>  'Bielorrusia'),
        array('id' => 24, 'short_description' => 'BE', 'long_description' =>  'Bélgica'),
        array('id' => 25, 'short_description' => 'BZ', 'long_description' =>  'Belice'),
        array('id' => 26, 'short_description' => 'BJ', 'long_description' =>  'Benin'),
        array('id' => 27, 'short_description' => 'BM', 'long_description' =>  'Bermudas'),
        array('id' => 28, 'short_description' => 'BT', 'long_description' =>  'Bhután'),
        array('id' => 29, 'short_description' => 'BO', 'long_description' =>  'Bolivia'),
        array('id' => 30, 'short_description' => 'BA', 'long_description' =>  'Bosnia y Herzegovina'),
        array('id' => 31, 'short_description' => 'BW', 'long_description' =>  'Botsuana'),
        array('id' => 32, 'short_description' => 'BV', 'long_description' =>  'Isla Bouvet'),
        array('id' => 33, 'short_description' => 'BR', 'long_description' =>  'Brasil'),
        array('id' => 34, 'short_description' => 'BN', 'long_description' =>  'Brunéi'),
        array('id' => 35, 'short_description' => 'BG', 'long_description' =>  'Bulgaria'),
        array('id' => 36, 'short_description' => 'BF', 'long_description' =>  'Burkina Faso'),
        array('id' => 37, 'short_description' => 'BI', 'long_description' =>  'Burundi'),
        array('id' => 38, 'short_description' => 'CV', 'long_description' =>  'Cabo Verde'),
        array('id' => 39, 'short_description' => 'KY', 'long_description' =>  'Islas Caimán'),
        array('id' => 40, 'short_description' => 'KH', 'long_description' =>  'Camboya'),
        array('id' => 41, 'short_description' => 'CM', 'long_description' =>  'Camerún'),
        array('id' => 42, 'short_description' => 'CA', 'long_description' =>  'Canadá'),
        array('id' => 43, 'short_description' => 'CF', 'long_description' =>  'República Centroafricana'),
        array('id' => 44, 'short_description' => 'TD', 'long_description' =>  'Chad'),
        array('id' => 45, 'short_description' => 'CZ', 'long_description' =>  'República Checa'),
        array('id' => 46, 'short_description' => 'CL', 'long_description' =>  'Chile'),
        array('id' => 47, 'short_description' => 'CN', 'long_description' =>  'China'),
        array('id' => 48, 'short_description' => 'CY', 'long_description' =>  'Chipre'),
        array('id' => 49, 'short_description' => 'CX', 'long_description' =>  'Isla de Navidad'),
        array('id' => 50, 'short_description' => 'VA', 'long_description' =>  'Ciudad del Vaticano'),
        array('id' => 51, 'short_description' => 'CC', 'long_description' =>  'Islas Cocos'),
        array('id' => 52, 'short_description' => 'CO', 'long_description' =>  'Colombia'),
        array('id' => 53, 'short_description' => 'KM', 'long_description' =>  'Comoras'),
        array('id' => 54, 'short_description' => 'CD', 'long_description' =>  'República Democrática del Congo'),
        array('id' => 55, 'short_description' => 'CG', 'long_description' =>  'Congo'),
        array('id' => 56, 'short_description' => 'CK', 'long_description' =>  'Islas Cook'),
        array('id' => 57, 'short_description' => 'KP', 'long_description' =>  'Corea del Norte'),
        array('id' => 58, 'short_description' => 'KR', 'long_description' =>  'Corea del Sur'),
        array('id' => 59, 'short_description' => 'CI', 'long_description' =>  'Costa de Marfil'),
        array('id' => 60, 'short_description' => 'CR', 'long_description' =>  'Costa Rica'),
        array('id' => 61, 'short_description' => 'HR', 'long_description' =>  'Croacia'),
        array('id' => 62, 'short_description' => 'CU', 'long_description' =>  'Cuba'),
        array('id' => 63, 'short_description' => 'DK', 'long_description' =>  'Dinamarca'),
        array('id' => 64, 'short_description' => 'DM', 'long_description' =>  'Dominica'),
        array('id' => 65, 'short_description' => 'DO', 'long_description' =>  'República Dominicana'),
        array('id' => 66, 'short_description' => 'EC', 'long_description' =>  'Ecuador'),
        array('id' => 67, 'short_description' => 'EG', 'long_description' =>  'Egipto'),
        array('id' => 68, 'short_description' => 'SV', 'long_description' =>  'El Salvador'),
        array('id' => 69, 'short_description' => 'AE', 'long_description' =>  'Emiratos Árabes Unidos'),
        array('id' => 70, 'short_description' => 'ER', 'long_description' =>  'Eritrea'),
        array('id' => 71, 'short_description' => 'SK', 'long_description' =>  'Eslovaquia'),
        array('id' => 72, 'short_description' => 'SI', 'long_description' =>  'Eslovenia'),
        array('id' => 73, 'short_description' => 'ES', 'long_description' =>  'España'),
        array('id' => 74, 'short_description' => 'UM', 'long_description' =>  'Islas ultramarinas de Estados Unidos'),
        array('id' => 75, 'short_description' => 'US', 'long_description' =>  'Estados Unidos'),
        array('id' => 76, 'short_description' => 'EE', 'long_description' =>  'Estonia'),
        array('id' => 77, 'short_description' => 'ET', 'long_description' =>  'Etiopía'),
        array('id' => 78, 'short_description' => 'FO', 'long_description' =>  'Islas Feroe'),
        array('id' => 79, 'short_description' => 'PH', 'long_description' =>  'Filipinas'),
        array('id' => 80, 'short_description' => 'FI', 'long_description' =>  'Finlandia'),
        array('id' => 81, 'short_description' => 'FJ', 'long_description' =>  'Fiyi'),
        array('id' => 82, 'short_description' => 'FR', 'long_description' =>  'Francia'),
        array('id' => 83, 'short_description' => 'GA', 'long_description' =>  'Gabón'),
        array('id' => 84, 'short_description' => 'GM', 'long_description' =>  'Gambia'),
        array('id' => 85, 'short_description' => 'GE', 'long_description' =>  'Georgia'),
        array('id' => 86, 'short_description' => 'GS', 'long_description' =>  'Islas Georgias del Sur y Sandwich del Sur'),
        array('id' => 87, 'short_description' => 'GH', 'long_description' =>  'Ghana'),
        array('id' => 88, 'short_description' => 'GI', 'long_description' =>  'Gibraltar'),
        array('id' => 89, 'short_description' => 'GD', 'long_description' =>  'Granada'),
        array('id' => 90, 'short_description' => 'GR', 'long_description' =>  'Grecia'),
        array('id' => 91, 'short_description' => 'GL', 'long_description' =>  'Groenlandia'),
        array('id' => 92, 'short_description' => 'GP', 'long_description' =>  'Guadalupe'),
        array('id' => 93, 'short_description' => 'GU', 'long_description' =>  'Guam'),
        array('id' => 94, 'short_description' => 'GT', 'long_description' =>  'Guatemala'),
        array('id' => 95, 'short_description' => 'GF', 'long_description' =>  'Guayana Francesa'),
        array('id' => 96, 'short_description' => 'GN', 'long_description' =>  'Guinea'),
        array('id' => 97, 'short_description' => 'GQ', 'long_description' =>  'Guinea Ecuatorial'),
        array('id' => 98, 'short_description' => 'GW', 'long_description' =>  'Guinea-Bissau'),
        array('id' => 99, 'short_description' => 'GY', 'long_description' =>  'Guyana'),
        array('id' => 100, 'short_description' => 'HT', 'long_description' =>  'Haití'),
        array('id' => 101, 'short_description' => 'HM', 'long_description' =>  'Islas Heard y McDonald'),
        array('id' => 102, 'short_description' => 'HN', 'long_description' =>  'Honduras'),
        array('id' => 103, 'short_description' => 'HK', 'long_description' =>  'Hong Kong'),
        array('id' => 104, 'short_description' => 'HU', 'long_description' =>  'Hungría'),
        array('id' => 105, 'short_description' => 'IN', 'long_description' =>  'India'),
        array('id' => 106, 'short_description' => 'ID', 'long_description' =>  'Indonesia'),
        array('id' => 107, 'short_description' => 'IR', 'long_description' =>  'Irán'),
        array('id' => 108, 'short_description' => 'IQ', 'long_description' =>  'Iraq'),
        array('id' => 109, 'short_description' => 'IE', 'long_description' =>  'Irlanda'),
        array('id' => 110, 'short_description' => 'IS', 'long_description' =>  'Islandia'),
        array('id' => 111, 'short_description' => 'IL', 'long_description' =>  'Israel'),
        array('id' => 112, 'short_description' => 'IT', 'long_description' =>  'Italia'),
        array('id' => 113, 'short_description' => 'JM', 'long_description' =>  'Jamaica'),
        array('id' => 114, 'short_description' => 'JP', 'long_description' =>  'Japón'),
        array('id' => 115, 'short_description' => 'JO', 'long_description' =>  'Jordania'),
        array('id' => 116, 'short_description' => 'KZ', 'long_description' =>  'Kazajstán'),
        array('id' => 117, 'short_description' => 'KE', 'long_description' =>  'Kenia'),
        array('id' => 118, 'short_description' => 'KG', 'long_description' =>  'Kirguistán'),
        array('id' => 119, 'short_description' => 'KI', 'long_description' =>  'Kiribati'),
        array('id' => 120, 'short_description' => 'KW', 'long_description' => 'Kuwait'),
        array('id' => 121, 'short_description' => 'LA', 'long_description' => 'Laos'),
        array('id' => 122, 'short_description' => 'LS', 'long_description' => 'Lesotho'),
        array('id' => 123, 'short_description' => 'LV', 'long_description' => 'Letonia'),
        array('id' => 124, 'short_description' => 'LB', 'long_description' => 'Líbano'),
        array('id' => 125, 'short_description' => 'LR', 'long_description' => 'Liberia'),
        array('id' => 126, 'short_description' => 'LY', 'long_description' => 'Libia'),
        array('id' => 127, 'short_description' => 'LI', 'long_description' => 'Liechtenstein'),
        array('id' => 128, 'short_description' => 'LT', 'long_description' => 'Lituania'),
        array('id' => 129, 'short_description' => 'LU', 'long_description' => 'Luxemburgo'),
        array('id' => 130, 'short_description' => 'MO', 'long_description' => 'Macao'),
        array('id' => 131, 'short_description' => 'MK', 'long_description' => 'ARY Macedonia'),
        array('id' => 132, 'short_description' => 'MG', 'long_description' => 'Madagascar'),
        array('id' => 133, 'short_description' => 'MY', 'long_description' => 'Malasia'),
        array('id' => 134, 'short_description' => 'MW', 'long_description' => 'Malawi'),
        array('id' => 135, 'short_description' => 'MV', 'long_description' => 'Maldivas'),
        array('id' => 136, 'short_description' => 'ML', 'long_description' => 'Malí'),
        array('id' => 137, 'short_description' => 'MT', 'long_description' => 'Malta'),
        array('id' => 138, 'short_description' => 'FK', 'long_description' => 'Islas Malvinas'),
        array('id' => 139, 'short_description' => 'MP', 'long_description' => 'Islas Marianas del Norte'),
        array('id' => 140, 'short_description' => 'MA', 'long_description' => 'Marruecos'),
        array('id' => 141, 'short_description' => 'MH', 'long_description' => 'Islas Marshall'),
        array('id' => 142, 'short_description' => 'MQ', 'long_description' => 'Martinica'),
        array('id' => 143, 'short_description' => 'MU', 'long_description' => 'Mauricio'),
        array('id' => 144, 'short_description' => 'MR', 'long_description' => 'Mauritania'),
        array('id' => 145, 'short_description' => 'YT', 'long_description' => 'Mayotte'),
        array('id' => 146, 'short_description' => 'MX', 'long_description' => 'México'),
        array('id' => 147, 'short_description' => 'FM', 'long_description' => 'Micronesia'),
        array('id' => 148, 'short_description' => 'MD', 'long_description' => 'Moldavia'),
        array('id' => 149, 'short_description' => 'MC', 'long_description' => 'Mónaco'),
        array('id' => 150, 'short_description' => 'MN', 'long_description' => 'Mongolia'),
        array('id' => 151, 'short_description' => 'MS', 'long_description' => 'Montserrat'),
        array('id' => 152, 'short_description' => 'MZ', 'long_description' => 'Mozambique'),
        array('id' => 153, 'short_description' => 'MM', 'long_description' => 'Myanmar'),
        array('id' => 154, 'short_description' => 'NA', 'long_description' => 'Namibia'),
        array('id' => 155, 'short_description' => 'NR', 'long_description' => 'Nauru'),
        array('id' => 156, 'short_description' => 'NP', 'long_description' => 'Nepal'),
        array('id' => 157, 'short_description' => 'NI', 'long_description' => 'Nicaragua'),
        array('id' => 158, 'short_description' => 'NE', 'long_description' => 'Níger'),
        array('id' => 159, 'short_description' => 'NG', 'long_description' => 'Nigeria'),
        array('id' => 160, 'short_description' => 'NU', 'long_description' => 'Niue'),
        array('id' => 161, 'short_description' => 'NF', 'long_description' => 'Isla Norfolk'),
        array('id' => 162, 'short_description' => 'NO', 'long_description' => 'Noruega'),
        array('id' => 163, 'short_description' => 'NC', 'long_description' => 'Nueva Caledonia'),
        array('id' => 164, 'short_description' => 'NZ', 'long_description' => 'Nueva Zelanda'),
        array('id' => 165, 'short_description' => 'OM', 'long_description' => 'Omán'),
        array('id' => 166, 'short_description' => 'NL', 'long_description' => 'Países Bajos'),
        array('id' => 167, 'short_description' => 'PK', 'long_description' => 'Pakistán'),
        array('id' => 168, 'short_description' => 'PW', 'long_description' => 'Palau'),
        array('id' => 169, 'short_description' => 'PS', 'long_description' => 'Palestina'),
        array('id' => 170, 'short_description' => 'PA', 'long_description' => 'Panamá'),
        array('id' => 171, 'short_description' => 'PG', 'long_description' => 'Papúa Nueva Guinea'),
        array('id' => 172, 'short_description' => 'PY', 'long_description' => 'Paraguay'),
        array('id' => 173, 'short_description' => 'PE', 'long_description' => 'Perú'),
        array('id' => 174, 'short_description' => 'PN', 'long_description' => 'Islas Pitcairn'),
        array('id' => 175, 'short_description' => 'PF', 'long_description' => 'Polinesia Francesa'),
        array('id' => 176, 'short_description' => 'PL', 'long_description' => 'Polonia'),
        array('id' => 177, 'short_description' => 'PT', 'long_description' => 'Portugal'),
        array('id' => 178, 'short_description' => 'PR', 'long_description' => 'Puerto Rico'),
        array('id' => 179, 'short_description' => 'QA', 'long_description' => 'Qatar'),
        array('id' => 180, 'short_description' => 'GB', 'long_description' => 'Reino Unido'),
        array('id' => 181, 'short_description' => 'RE', 'long_description' => 'Reunión'),
        array('id' => 182, 'short_description' => 'RW', 'long_description' => 'Ruanda'),
        array('id' => 183, 'short_description' => 'RO', 'long_description' => 'Rumania'),
        array('id' => 184, 'short_description' => 'RU', 'long_description' => 'Rusia'),
        array('id' => 185, 'short_description' => 'EH', 'long_description' => 'Sahara Occidental'),
        array('id' => 186, 'short_description' => 'SB', 'long_description' => 'Islas Salomón'),
        array('id' => 187, 'short_description' => 'WS', 'long_description' => 'Samoa'),
        array('id' => 188, 'short_description' => 'AS', 'long_description' => 'Samoa Americana'),
        array('id' => 189, 'short_description' => 'KN', 'long_description' => 'San Cristóbal y Nevis'),
        array('id' => 190, 'short_description' => 'SM', 'long_description' => 'San Marino'),
        array('id' => 191, 'short_description' => 'PM', 'long_description' => 'San Pedro y Miquelón'),
        array('id' => 192, 'short_description' => 'VC', 'long_description' => 'San Vicente y las Granadinas'),
        array('id' => 193, 'short_description' => 'SH', 'long_description' => 'Santa Helena'),
        array('id' => 194, 'short_description' => 'LC', 'long_description' => 'Santa Lucía'),
        array('id' => 195, 'short_description' => 'ST', 'long_description' => 'Santo Tomé y Príncipe'),
        array('id' => 196, 'short_description' => 'SN', 'long_description' => 'Senegal'),
        array('id' => 197, 'short_description' => 'CS', 'long_description' => 'Serbia y Montenegro'),
        array('id' => 198, 'short_description' => 'SC', 'long_description' => 'Seychelles'),
        array('id' => 199, 'short_description' => 'SL', 'long_description' => 'Sierra Leona'),
        array('id' => 200, 'short_description' => 'SG', 'long_description' => 'Singapur'),
        array('id' => 201, 'short_description' => 'SY', 'long_description' => 'Siria'),
        array('id' => 202, 'short_description' => 'SO', 'long_description' => 'Somalia'),
        array('id' => 203, 'short_description' => 'LK', 'long_description' => 'Sri Lanka'),
        array('id' => 204, 'short_description' => 'SZ', 'long_description' => 'Suazilandia'),
        array('id' => 205, 'short_description' => 'ZA', 'long_description' => 'Sudáfrica'),
        array('id' => 206, 'short_description' => 'SD', 'long_description' => 'Sudán'),
        array('id' => 207, 'short_description' => 'SE', 'long_description' => 'Suecia'),
        array('id' => 208, 'short_description' => 'CH', 'long_description' => 'Suiza'),
        array('id' => 209, 'short_description' => 'SR', 'long_description' => 'Surinam'),
        array('id' => 210, 'short_description' => 'SJ', 'long_description' => 'Svalbard y Jan Mayen'),
        array('id' => 211, 'short_description' => 'TH', 'long_description' => 'Tailandia'),
        array('id' => 212, 'short_description' => 'TW', 'long_description' => 'Taiwán'),
        array('id' => 213, 'short_description' => 'TZ', 'long_description' => 'Tanzania'),
        array('id' => 214, 'short_description' => 'TJ', 'long_description' => 'Tayikistán'),
        array('id' => 215, 'short_description' => 'IO', 'long_description' => 'Territorio Británico del Océano Índico'),
        array('id' => 216, 'short_description' => 'TF', 'long_description' => 'Territorios Australes Franceses'),
        array('id' => 217, 'short_description' => 'TL', 'long_description' => 'Timor Oriental'),
        array('id' => 218, 'short_description' => 'TG', 'long_description' => 'Togo'),
        array('id' => 219, 'short_description' => 'TK', 'long_description' => 'Tokelau'),
        array('id' => 220, 'short_description' => 'TO', 'long_description' => 'Tonga'),
        array('id' => 221, 'short_description' => 'TT', 'long_description' => 'Trinidad y Tobago'),
        array('id' => 222, 'short_description' => 'TN', 'long_description' => 'Túnez'),
        array('id' => 223, 'short_description' => 'TC', 'long_description' => 'Islas Turcas y Caicos'),
        array('id' => 224, 'short_description' => 'TM', 'long_description' => 'Turkmenistán'),
        array('id' => 225, 'short_description' => 'TR', 'long_description' => 'Turquía'),
        array('id' => 226, 'short_description' => 'TV', 'long_description' => 'Tuvalu'),
        array('id' => 227, 'short_description' => 'UA', 'long_description' => 'Ucrania'),
        array('id' => 228, 'short_description' => 'UG', 'long_description' => 'Uganda'),
        array('id' => 229, 'short_description' => 'UY', 'long_description' => 'Uruguay'),
        array('id' => 230, 'short_description' => 'UZ', 'long_description' => 'Uzbekistán'),
        array('id' => 231, 'short_description' => 'VU', 'long_description' => 'Vanuatu'),
        array('id' => 232, 'short_description' => 'VE', 'long_description' => 'Venezuela'),
        array('id' => 233, 'short_description' => 'VN', 'long_description' => 'Vietnam'),
        array('id' => 234, 'short_description' => 'VG', 'long_description' => 'Islas Vírgenes Británicas'),
        array('id' => 235, 'short_description' => 'VI', 'long_description' => 'Islas Vírgenes de los Estados Unidos'),
        array('id' => 236, 'short_description' => 'WF', 'long_description' => 'Wallis y Futuna'),
        array('id' => 237, 'short_description' => 'YE', 'long_description' => 'Yemen'),
        array('id' => 238, 'short_description' => 'DJ', 'long_description' => 'Yibuti'),
        array('id' => 239, 'short_description' => 'ZM', 'long_description' => 'Zambia'),
        array('id' => 240, 'short_description' => 'ZW', 'long_description' => 'Zimbabue'),

    );


    foreach ($countries as $key => $item) {
        Country::create([
            'id' =>  $item['id'],
            'short_description' => mb_strtoupper($item['short_description']),
            'long_description' => mb_strtoupper($item['long_description']),
        ]);
    }
}

}
`

@cesarHernandezF
Copy link

Muchas gracias

@JonayMedina
Copy link

LARAVEL

`<?php

use App\Country;
use Illuminate\Database\Seeder;
use PHPUnit\Framework\Constraint\Count;

class CountrySeeder extends Seeder
{
/**

  • Run the database seeds.
  • @return void
    */
    public function run()
    {
    $countries = array(
        array('id' => 1,  'short_description' => 'AF', 'long_description' => 'Afganistán'),
        array('id' => 2,  'short_description' => 'AX', 'long_description' => 'Islas Gland'),
        array('id' => 3,  'short_description' => 'AL', 'long_description' => 'Albania'),
        array('id' => 4,  'short_description' => 'DE', 'long_description' => 'Alemania'),
        array('id' => 5,  'short_description' => 'AD', 'long_description' => 'Andorra'),
        array('id' => 6,  'short_description' => 'AO', 'long_description' => 'Angola'),
        array('id' => 7,  'short_description' => 'AI', 'long_description' => 'Anguilla'),
        array('id' => 8,  'short_description' => 'AQ', 'long_description' => 'Antártida'),
        array('id' => 9,  'short_description' => 'AG', 'long_description' => 'Antigua y Barbuda'),
        array('id' => 10, 'short_description' => 'AN', 'long_description' =>  'Antillas Holandesas'),
        array('id' => 11, 'short_description' => 'SA', 'long_description' =>  'Arabia Saudí'),
        array('id' => 12, 'short_description' => 'DZ', 'long_description' =>  'Argelia'),
        array('id' => 13, 'short_description' => 'AR', 'long_description' =>  'Argentina'),
        array('id' => 14, 'short_description' => 'AM', 'long_description' =>  'Armenia'),
        array('id' => 15, 'short_description' => 'AW', 'long_description' =>  'Aruba'),
        array('id' => 16, 'short_description' => 'AU', 'long_description' =>  'Australia'),
        array('id' => 17, 'short_description' => 'AT', 'long_description' =>  'Austria'),
        array('id' => 18, 'short_description' => 'AZ', 'long_description' =>  'Azerbaiyán'),
        array('id' => 19, 'short_description' => 'BS', 'long_description' =>  'Bahamas'),
        array('id' => 20, 'short_description' => 'BH', 'long_description' =>  'Bahréin'),
        array('id' => 21, 'short_description' => 'BD', 'long_description' =>  'Bangladesh'),
        array('id' => 22, 'short_description' => 'BB', 'long_description' =>  'Barbados'),
        array('id' => 23, 'short_description' => 'BY', 'long_description' =>  'Bielorrusia'),
        array('id' => 24, 'short_description' => 'BE', 'long_description' =>  'Bélgica'),
        array('id' => 25, 'short_description' => 'BZ', 'long_description' =>  'Belice'),
        array('id' => 26, 'short_description' => 'BJ', 'long_description' =>  'Benin'),
        array('id' => 27, 'short_description' => 'BM', 'long_description' =>  'Bermudas'),
        array('id' => 28, 'short_description' => 'BT', 'long_description' =>  'Bhután'),
        array('id' => 29, 'short_description' => 'BO', 'long_description' =>  'Bolivia'),
        array('id' => 30, 'short_description' => 'BA', 'long_description' =>  'Bosnia y Herzegovina'),
        array('id' => 31, 'short_description' => 'BW', 'long_description' =>  'Botsuana'),
        array('id' => 32, 'short_description' => 'BV', 'long_description' =>  'Isla Bouvet'),
        array('id' => 33, 'short_description' => 'BR', 'long_description' =>  'Brasil'),
        array('id' => 34, 'short_description' => 'BN', 'long_description' =>  'Brunéi'),
        array('id' => 35, 'short_description' => 'BG', 'long_description' =>  'Bulgaria'),
        array('id' => 36, 'short_description' => 'BF', 'long_description' =>  'Burkina Faso'),
        array('id' => 37, 'short_description' => 'BI', 'long_description' =>  'Burundi'),
        array('id' => 38, 'short_description' => 'CV', 'long_description' =>  'Cabo Verde'),
        array('id' => 39, 'short_description' => 'KY', 'long_description' =>  'Islas Caimán'),
        array('id' => 40, 'short_description' => 'KH', 'long_description' =>  'Camboya'),
        array('id' => 41, 'short_description' => 'CM', 'long_description' =>  'Camerún'),
        array('id' => 42, 'short_description' => 'CA', 'long_description' =>  'Canadá'),
        array('id' => 43, 'short_description' => 'CF', 'long_description' =>  'República Centroafricana'),
        array('id' => 44, 'short_description' => 'TD', 'long_description' =>  'Chad'),
        array('id' => 45, 'short_description' => 'CZ', 'long_description' =>  'República Checa'),
        array('id' => 46, 'short_description' => 'CL', 'long_description' =>  'Chile'),
        array('id' => 47, 'short_description' => 'CN', 'long_description' =>  'China'),
        array('id' => 48, 'short_description' => 'CY', 'long_description' =>  'Chipre'),
        array('id' => 49, 'short_description' => 'CX', 'long_description' =>  'Isla de Navidad'),
        array('id' => 50, 'short_description' => 'VA', 'long_description' =>  'Ciudad del Vaticano'),
        array('id' => 51, 'short_description' => 'CC', 'long_description' =>  'Islas Cocos'),
        array('id' => 52, 'short_description' => 'CO', 'long_description' =>  'Colombia'),
        array('id' => 53, 'short_description' => 'KM', 'long_description' =>  'Comoras'),
        array('id' => 54, 'short_description' => 'CD', 'long_description' =>  'República Democrática del Congo'),
        array('id' => 55, 'short_description' => 'CG', 'long_description' =>  'Congo'),
        array('id' => 56, 'short_description' => 'CK', 'long_description' =>  'Islas Cook'),
        array('id' => 57, 'short_description' => 'KP', 'long_description' =>  'Corea del Norte'),
        array('id' => 58, 'short_description' => 'KR', 'long_description' =>  'Corea del Sur'),
        array('id' => 59, 'short_description' => 'CI', 'long_description' =>  'Costa de Marfil'),
        array('id' => 60, 'short_description' => 'CR', 'long_description' =>  'Costa Rica'),
        array('id' => 61, 'short_description' => 'HR', 'long_description' =>  'Croacia'),
        array('id' => 62, 'short_description' => 'CU', 'long_description' =>  'Cuba'),
        array('id' => 63, 'short_description' => 'DK', 'long_description' =>  'Dinamarca'),
        array('id' => 64, 'short_description' => 'DM', 'long_description' =>  'Dominica'),
        array('id' => 65, 'short_description' => 'DO', 'long_description' =>  'República Dominicana'),
        array('id' => 66, 'short_description' => 'EC', 'long_description' =>  'Ecuador'),
        array('id' => 67, 'short_description' => 'EG', 'long_description' =>  'Egipto'),
        array('id' => 68, 'short_description' => 'SV', 'long_description' =>  'El Salvador'),
        array('id' => 69, 'short_description' => 'AE', 'long_description' =>  'Emiratos Árabes Unidos'),
        array('id' => 70, 'short_description' => 'ER', 'long_description' =>  'Eritrea'),
        array('id' => 71, 'short_description' => 'SK', 'long_description' =>  'Eslovaquia'),
        array('id' => 72, 'short_description' => 'SI', 'long_description' =>  'Eslovenia'),
        array('id' => 73, 'short_description' => 'ES', 'long_description' =>  'España'),
        array('id' => 74, 'short_description' => 'UM', 'long_description' =>  'Islas ultramarinas de Estados Unidos'),
        array('id' => 75, 'short_description' => 'US', 'long_description' =>  'Estados Unidos'),
        array('id' => 76, 'short_description' => 'EE', 'long_description' =>  'Estonia'),
        array('id' => 77, 'short_description' => 'ET', 'long_description' =>  'Etiopía'),
        array('id' => 78, 'short_description' => 'FO', 'long_description' =>  'Islas Feroe'),
        array('id' => 79, 'short_description' => 'PH', 'long_description' =>  'Filipinas'),
        array('id' => 80, 'short_description' => 'FI', 'long_description' =>  'Finlandia'),
        array('id' => 81, 'short_description' => 'FJ', 'long_description' =>  'Fiyi'),
        array('id' => 82, 'short_description' => 'FR', 'long_description' =>  'Francia'),
        array('id' => 83, 'short_description' => 'GA', 'long_description' =>  'Gabón'),
        array('id' => 84, 'short_description' => 'GM', 'long_description' =>  'Gambia'),
        array('id' => 85, 'short_description' => 'GE', 'long_description' =>  'Georgia'),
        array('id' => 86, 'short_description' => 'GS', 'long_description' =>  'Islas Georgias del Sur y Sandwich del Sur'),
        array('id' => 87, 'short_description' => 'GH', 'long_description' =>  'Ghana'),
        array('id' => 88, 'short_description' => 'GI', 'long_description' =>  'Gibraltar'),
        array('id' => 89, 'short_description' => 'GD', 'long_description' =>  'Granada'),
        array('id' => 90, 'short_description' => 'GR', 'long_description' =>  'Grecia'),
        array('id' => 91, 'short_description' => 'GL', 'long_description' =>  'Groenlandia'),
        array('id' => 92, 'short_description' => 'GP', 'long_description' =>  'Guadalupe'),
        array('id' => 93, 'short_description' => 'GU', 'long_description' =>  'Guam'),
        array('id' => 94, 'short_description' => 'GT', 'long_description' =>  'Guatemala'),
        array('id' => 95, 'short_description' => 'GF', 'long_description' =>  'Guayana Francesa'),
        array('id' => 96, 'short_description' => 'GN', 'long_description' =>  'Guinea'),
        array('id' => 97, 'short_description' => 'GQ', 'long_description' =>  'Guinea Ecuatorial'),
        array('id' => 98, 'short_description' => 'GW', 'long_description' =>  'Guinea-Bissau'),
        array('id' => 99, 'short_description' => 'GY', 'long_description' =>  'Guyana'),
        array('id' => 100, 'short_description' => 'HT', 'long_description' =>  'Haití'),
        array('id' => 101, 'short_description' => 'HM', 'long_description' =>  'Islas Heard y McDonald'),
        array('id' => 102, 'short_description' => 'HN', 'long_description' =>  'Honduras'),
        array('id' => 103, 'short_description' => 'HK', 'long_description' =>  'Hong Kong'),
        array('id' => 104, 'short_description' => 'HU', 'long_description' =>  'Hungría'),
        array('id' => 105, 'short_description' => 'IN', 'long_description' =>  'India'),
        array('id' => 106, 'short_description' => 'ID', 'long_description' =>  'Indonesia'),
        array('id' => 107, 'short_description' => 'IR', 'long_description' =>  'Irán'),
        array('id' => 108, 'short_description' => 'IQ', 'long_description' =>  'Iraq'),
        array('id' => 109, 'short_description' => 'IE', 'long_description' =>  'Irlanda'),
        array('id' => 110, 'short_description' => 'IS', 'long_description' =>  'Islandia'),
        array('id' => 111, 'short_description' => 'IL', 'long_description' =>  'Israel'),
        array('id' => 112, 'short_description' => 'IT', 'long_description' =>  'Italia'),
        array('id' => 113, 'short_description' => 'JM', 'long_description' =>  'Jamaica'),
        array('id' => 114, 'short_description' => 'JP', 'long_description' =>  'Japón'),
        array('id' => 115, 'short_description' => 'JO', 'long_description' =>  'Jordania'),
        array('id' => 116, 'short_description' => 'KZ', 'long_description' =>  'Kazajstán'),
        array('id' => 117, 'short_description' => 'KE', 'long_description' =>  'Kenia'),
        array('id' => 118, 'short_description' => 'KG', 'long_description' =>  'Kirguistán'),
        array('id' => 119, 'short_description' => 'KI', 'long_description' =>  'Kiribati'),
        array('id' => 120, 'short_description' => 'KW', 'long_description' => 'Kuwait'),
        array('id' => 121, 'short_description' => 'LA', 'long_description' => 'Laos'),
        array('id' => 122, 'short_description' => 'LS', 'long_description' => 'Lesotho'),
        array('id' => 123, 'short_description' => 'LV', 'long_description' => 'Letonia'),
        array('id' => 124, 'short_description' => 'LB', 'long_description' => 'Líbano'),
        array('id' => 125, 'short_description' => 'LR', 'long_description' => 'Liberia'),
        array('id' => 126, 'short_description' => 'LY', 'long_description' => 'Libia'),
        array('id' => 127, 'short_description' => 'LI', 'long_description' => 'Liechtenstein'),
        array('id' => 128, 'short_description' => 'LT', 'long_description' => 'Lituania'),
        array('id' => 129, 'short_description' => 'LU', 'long_description' => 'Luxemburgo'),
        array('id' => 130, 'short_description' => 'MO', 'long_description' => 'Macao'),
        array('id' => 131, 'short_description' => 'MK', 'long_description' => 'ARY Macedonia'),
        array('id' => 132, 'short_description' => 'MG', 'long_description' => 'Madagascar'),
        array('id' => 133, 'short_description' => 'MY', 'long_description' => 'Malasia'),
        array('id' => 134, 'short_description' => 'MW', 'long_description' => 'Malawi'),
        array('id' => 135, 'short_description' => 'MV', 'long_description' => 'Maldivas'),
        array('id' => 136, 'short_description' => 'ML', 'long_description' => 'Malí'),
        array('id' => 137, 'short_description' => 'MT', 'long_description' => 'Malta'),
        array('id' => 138, 'short_description' => 'FK', 'long_description' => 'Islas Malvinas'),
        array('id' => 139, 'short_description' => 'MP', 'long_description' => 'Islas Marianas del Norte'),
        array('id' => 140, 'short_description' => 'MA', 'long_description' => 'Marruecos'),
        array('id' => 141, 'short_description' => 'MH', 'long_description' => 'Islas Marshall'),
        array('id' => 142, 'short_description' => 'MQ', 'long_description' => 'Martinica'),
        array('id' => 143, 'short_description' => 'MU', 'long_description' => 'Mauricio'),
        array('id' => 144, 'short_description' => 'MR', 'long_description' => 'Mauritania'),
        array('id' => 145, 'short_description' => 'YT', 'long_description' => 'Mayotte'),
        array('id' => 146, 'short_description' => 'MX', 'long_description' => 'México'),
        array('id' => 147, 'short_description' => 'FM', 'long_description' => 'Micronesia'),
        array('id' => 148, 'short_description' => 'MD', 'long_description' => 'Moldavia'),
        array('id' => 149, 'short_description' => 'MC', 'long_description' => 'Mónaco'),
        array('id' => 150, 'short_description' => 'MN', 'long_description' => 'Mongolia'),
        array('id' => 151, 'short_description' => 'MS', 'long_description' => 'Montserrat'),
        array('id' => 152, 'short_description' => 'MZ', 'long_description' => 'Mozambique'),
        array('id' => 153, 'short_description' => 'MM', 'long_description' => 'Myanmar'),
        array('id' => 154, 'short_description' => 'NA', 'long_description' => 'Namibia'),
        array('id' => 155, 'short_description' => 'NR', 'long_description' => 'Nauru'),
        array('id' => 156, 'short_description' => 'NP', 'long_description' => 'Nepal'),
        array('id' => 157, 'short_description' => 'NI', 'long_description' => 'Nicaragua'),
        array('id' => 158, 'short_description' => 'NE', 'long_description' => 'Níger'),
        array('id' => 159, 'short_description' => 'NG', 'long_description' => 'Nigeria'),
        array('id' => 160, 'short_description' => 'NU', 'long_description' => 'Niue'),
        array('id' => 161, 'short_description' => 'NF', 'long_description' => 'Isla Norfolk'),
        array('id' => 162, 'short_description' => 'NO', 'long_description' => 'Noruega'),
        array('id' => 163, 'short_description' => 'NC', 'long_description' => 'Nueva Caledonia'),
        array('id' => 164, 'short_description' => 'NZ', 'long_description' => 'Nueva Zelanda'),
        array('id' => 165, 'short_description' => 'OM', 'long_description' => 'Omán'),
        array('id' => 166, 'short_description' => 'NL', 'long_description' => 'Países Bajos'),
        array('id' => 167, 'short_description' => 'PK', 'long_description' => 'Pakistán'),
        array('id' => 168, 'short_description' => 'PW', 'long_description' => 'Palau'),
        array('id' => 169, 'short_description' => 'PS', 'long_description' => 'Palestina'),
        array('id' => 170, 'short_description' => 'PA', 'long_description' => 'Panamá'),
        array('id' => 171, 'short_description' => 'PG', 'long_description' => 'Papúa Nueva Guinea'),
        array('id' => 172, 'short_description' => 'PY', 'long_description' => 'Paraguay'),
        array('id' => 173, 'short_description' => 'PE', 'long_description' => 'Perú'),
        array('id' => 174, 'short_description' => 'PN', 'long_description' => 'Islas Pitcairn'),
        array('id' => 175, 'short_description' => 'PF', 'long_description' => 'Polinesia Francesa'),
        array('id' => 176, 'short_description' => 'PL', 'long_description' => 'Polonia'),
        array('id' => 177, 'short_description' => 'PT', 'long_description' => 'Portugal'),
        array('id' => 178, 'short_description' => 'PR', 'long_description' => 'Puerto Rico'),
        array('id' => 179, 'short_description' => 'QA', 'long_description' => 'Qatar'),
        array('id' => 180, 'short_description' => 'GB', 'long_description' => 'Reino Unido'),
        array('id' => 181, 'short_description' => 'RE', 'long_description' => 'Reunión'),
        array('id' => 182, 'short_description' => 'RW', 'long_description' => 'Ruanda'),
        array('id' => 183, 'short_description' => 'RO', 'long_description' => 'Rumania'),
        array('id' => 184, 'short_description' => 'RU', 'long_description' => 'Rusia'),
        array('id' => 185, 'short_description' => 'EH', 'long_description' => 'Sahara Occidental'),
        array('id' => 186, 'short_description' => 'SB', 'long_description' => 'Islas Salomón'),
        array('id' => 187, 'short_description' => 'WS', 'long_description' => 'Samoa'),
        array('id' => 188, 'short_description' => 'AS', 'long_description' => 'Samoa Americana'),
        array('id' => 189, 'short_description' => 'KN', 'long_description' => 'San Cristóbal y Nevis'),
        array('id' => 190, 'short_description' => 'SM', 'long_description' => 'San Marino'),
        array('id' => 191, 'short_description' => 'PM', 'long_description' => 'San Pedro y Miquelón'),
        array('id' => 192, 'short_description' => 'VC', 'long_description' => 'San Vicente y las Granadinas'),
        array('id' => 193, 'short_description' => 'SH', 'long_description' => 'Santa Helena'),
        array('id' => 194, 'short_description' => 'LC', 'long_description' => 'Santa Lucía'),
        array('id' => 195, 'short_description' => 'ST', 'long_description' => 'Santo Tomé y Príncipe'),
        array('id' => 196, 'short_description' => 'SN', 'long_description' => 'Senegal'),
        array('id' => 197, 'short_description' => 'CS', 'long_description' => 'Serbia y Montenegro'),
        array('id' => 198, 'short_description' => 'SC', 'long_description' => 'Seychelles'),
        array('id' => 199, 'short_description' => 'SL', 'long_description' => 'Sierra Leona'),
        array('id' => 200, 'short_description' => 'SG', 'long_description' => 'Singapur'),
        array('id' => 201, 'short_description' => 'SY', 'long_description' => 'Siria'),
        array('id' => 202, 'short_description' => 'SO', 'long_description' => 'Somalia'),
        array('id' => 203, 'short_description' => 'LK', 'long_description' => 'Sri Lanka'),
        array('id' => 204, 'short_description' => 'SZ', 'long_description' => 'Suazilandia'),
        array('id' => 205, 'short_description' => 'ZA', 'long_description' => 'Sudáfrica'),
        array('id' => 206, 'short_description' => 'SD', 'long_description' => 'Sudán'),
        array('id' => 207, 'short_description' => 'SE', 'long_description' => 'Suecia'),
        array('id' => 208, 'short_description' => 'CH', 'long_description' => 'Suiza'),
        array('id' => 209, 'short_description' => 'SR', 'long_description' => 'Surinam'),
        array('id' => 210, 'short_description' => 'SJ', 'long_description' => 'Svalbard y Jan Mayen'),
        array('id' => 211, 'short_description' => 'TH', 'long_description' => 'Tailandia'),
        array('id' => 212, 'short_description' => 'TW', 'long_description' => 'Taiwán'),
        array('id' => 213, 'short_description' => 'TZ', 'long_description' => 'Tanzania'),
        array('id' => 214, 'short_description' => 'TJ', 'long_description' => 'Tayikistán'),
        array('id' => 215, 'short_description' => 'IO', 'long_description' => 'Territorio Británico del Océano Índico'),
        array('id' => 216, 'short_description' => 'TF', 'long_description' => 'Territorios Australes Franceses'),
        array('id' => 217, 'short_description' => 'TL', 'long_description' => 'Timor Oriental'),
        array('id' => 218, 'short_description' => 'TG', 'long_description' => 'Togo'),
        array('id' => 219, 'short_description' => 'TK', 'long_description' => 'Tokelau'),
        array('id' => 220, 'short_description' => 'TO', 'long_description' => 'Tonga'),
        array('id' => 221, 'short_description' => 'TT', 'long_description' => 'Trinidad y Tobago'),
        array('id' => 222, 'short_description' => 'TN', 'long_description' => 'Túnez'),
        array('id' => 223, 'short_description' => 'TC', 'long_description' => 'Islas Turcas y Caicos'),
        array('id' => 224, 'short_description' => 'TM', 'long_description' => 'Turkmenistán'),
        array('id' => 225, 'short_description' => 'TR', 'long_description' => 'Turquía'),
        array('id' => 226, 'short_description' => 'TV', 'long_description' => 'Tuvalu'),
        array('id' => 227, 'short_description' => 'UA', 'long_description' => 'Ucrania'),
        array('id' => 228, 'short_description' => 'UG', 'long_description' => 'Uganda'),
        array('id' => 229, 'short_description' => 'UY', 'long_description' => 'Uruguay'),
        array('id' => 230, 'short_description' => 'UZ', 'long_description' => 'Uzbekistán'),
        array('id' => 231, 'short_description' => 'VU', 'long_description' => 'Vanuatu'),
        array('id' => 232, 'short_description' => 'VE', 'long_description' => 'Venezuela'),
        array('id' => 233, 'short_description' => 'VN', 'long_description' => 'Vietnam'),
        array('id' => 234, 'short_description' => 'VG', 'long_description' => 'Islas Vírgenes Británicas'),
        array('id' => 235, 'short_description' => 'VI', 'long_description' => 'Islas Vírgenes de los Estados Unidos'),
        array('id' => 236, 'short_description' => 'WF', 'long_description' => 'Wallis y Futuna'),
        array('id' => 237, 'short_description' => 'YE', 'long_description' => 'Yemen'),
        array('id' => 238, 'short_description' => 'DJ', 'long_description' => 'Yibuti'),
        array('id' => 239, 'short_description' => 'ZM', 'long_description' => 'Zambia'),
        array('id' => 240, 'short_description' => 'ZW', 'long_description' => 'Zimbabue'),

    );


    foreach ($countries as $key => $item) {
        Country::create([
            'id' =>  $item['id'],
            'short_description' => mb_strtoupper($item['short_description']),
            'long_description' => mb_strtoupper($item['long_description']),
        ]);
    }
}

}
`

gracias por el seeder
Excelente.

@eltanquedyr
Copy link

Gracias!!!

@Mizar-Contasti
Copy link

$mexico_id = 146;

$mexicoEstados = [
[
'name' => 'Aguascalientes',
'country_id' => $mexico_id
],
[
'name' => 'Baja California',
'country_id' => $mexico_id
],
[
'name' => 'Baja California Sur',
'country_id' => $mexico_id
],
[
'name' => 'Campeche',
'country_id' => $mexico_id
],
[
'name' => 'Coahuila de Zaragoza',
'country_id' => $mexico_id
],
[
'name' => 'Colima',
'country_id' => $mexico_id
],
[
'name' => 'Chiapas',
'country_id' => $mexico_id
],
[
'name' => 'Chihuahua',
'country_id' => $mexico_id
],
[
'name' => 'Distrito Federal',
'country_id' => $mexico_id
],
[
'name' => 'Durango',
'country_id' => $mexico_id
],
[
'name' => 'Guanajuato',
'country_id' => $mexico_id
],
[
'name' => 'Guerrero',
'country_id' => $mexico_id
],
[
'name' => 'Hidalgo',
'country_id' => $mexico_id
],
[
'name' => 'Jalisco',
'country_id' => $mexico_id
],
[
'name' => 'México',
'country_id' => $mexico_id
],
[
'name' => 'Michoacán de Ocampo',
'country_id' => $mexico_id
],
[
'name' => 'Morelos',
'country_id' => $mexico_id
],
[
'name' => 'Nayarit',
'country_id' => $mexico_id
],
[
'name' => 'Nuevo León',
'country_id' => $mexico_id
],
[
'name' => 'Oaxaca de Juárez',
'country_id' => $mexico_id
],
[
'name' => 'Puebla',
'country_id' => $mexico_id
],
[
'name' => 'Querétaro',
'country_id' => $mexico_id
],
[
'name' => 'Qana Roo',
'country_id' => $mexico_id
],
[
'name' => 'San Luis Potosí',
'country_id' => $mexico_id
],
[
'name' => 'Sinaloa',
'country_id' => $mexico_id
],
[
'name' => 'Sonora',
'country_id' => $mexico_id
],
[
'name' => 'Tabasco',
'country_id' => $mexico_id
],
[
'name' => 'Tamaulipas',
'country_id' => $mexico_id
],
[
'name' => 'Tlaxcala',
'country_id' => $mexico_id
],
[
'name' => 'Veracruz de Ignacio de la Llave',
'country_id' => $mexico_id
],
[
'name' => 'Yucatán',
'country_id' => $mexico_id
],
[
'name' => 'Zacatecas',
'country_id' => $mexico_id
]
];

Thanks you

@jmsarmientopalma
Copy link

Muchas gracias!!

@codigobyte-repo
Copy link

Muchas gracias!!

@gbanezca
Copy link

Graciaaas

@JGuillenY
Copy link

Tanto tiempo ahorrado, muchas gracias :D !!

@felipejoq
Copy link

This is a total countries? oh! wow, thanks for sharing!

@LordPalma
Copy link

muchas gracias es de mucha ayuda

@yupiii
Copy link

yupiii commented Dec 14, 2023

Gracias!!

@claudiogg88
Copy link

gracias!!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment