Skip to content

Instantly share code, notes, and snippets.

@amieiro

amieiro/SQL para insertar las provincias españolas

Created November 30, 2016 11:48
Show Gist options
  • Save amieiro/eec790e96a0e3355b5702cc5df289b54 to your computer and use it in GitHub Desktop.
Save amieiro/eec790e96a0e3355b5702cc5df289b54 to your computer and use it in GitHub Desktop.
Download ZIP
SQL para insertar las provincias españolas
Raw
SQL para insertar las provincias españolas
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Araba/Álava', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Albacete', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Alicante/Alacant', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Almería', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Ávila', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Badajoz', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Balears (Illes)', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Barcelona', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Burgos', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Cáceres', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Cádiz', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Castellón/Castelló', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Ciudad Real', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Córdoba', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Coruña (A)', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Cuenca', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Girona', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Granada', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Guadalajara', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Guipuzkoa', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Huelva', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Huesca', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Jaén', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'León', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Lleida', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Rioja (La)', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Lugo', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Madrid', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Málaga', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Murcia', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Navarra', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Ourense', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Asturias', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Palencia', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Palmas (Las)', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Pontevedra', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Salamanca', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Santa Cruz de Tenerife', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Cantabria', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Segovia', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Sevilla', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Soria', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Tarragona', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Teruel', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Toledo', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Valencia/València', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Valladolid', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Bizkaia', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Zamora', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Zaragoza', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Ceuta', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
INSERT INTO `mi_base_de_datos`.`provincias` (`id`, `nombre`, `created_at`, `updated_at`) VALUES (NULL, 'Melilla', CURRENT_TIMESTAMP(), CURRENT_TIMESTAMP());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment