advanced code snippet search

Posted By

luman on 01/09/08


Tagged

sql espaa


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

tonic


Table Provincias España

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. CREATE TABLE `provincias` (
  2.   `id` int(11) NOT NULL AUTO_INCREMENT,
  3.   `nombre` varchar(125) DEFAULT NULL,
  4.   PRIMARY KEY  (`id`)
  5. ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  6.  
  7. INSERT INTO `provincias` VALUES (15,'Coruña, A');
  8. INSERT INTO `provincias` VALUES (1,'Alava');
  9. INSERT INTO `provincias` VALUES (2,'Albacete');
  10. INSERT INTO `provincias` VALUES (3,'Alicante');
  11. INSERT INTO `provincias` VALUES (4,'Almería');
  12. INSERT INTO `provincias` VALUES (33,'Asturias');
  13. INSERT INTO `provincias` VALUES (5,'Avila');
  14. INSERT INTO `provincias` VALUES (6,'Badajoz');
  15. INSERT INTO `provincias` VALUES (8,'Barcelona');
  16. INSERT INTO `provincias` VALUES (9,'Burgos');
  17. INSERT INTO `provincias` VALUES (10,'Cáceres');
  18. INSERT INTO `provincias` VALUES (11,'Cádiz');
  19. INSERT INTO `provincias` VALUES (39,'Cantabria');
  20. INSERT INTO `provincias` VALUES (12,'Cástellón');
  21. INSERT INTO `provincias` VALUES (51,'Ceuta');
  22. INSERT INTO `provincias` VALUES (13,'Ciudad Real');
  23. INSERT INTO `provincias` VALUES (16,'Cuenca');
  24. INSERT INTO `provincias` VALUES (14,'Córdoba');
  25. INSERT INTO `provincias` VALUES (17,'Girona');
  26. INSERT INTO `provincias` VALUES (18,'Granada');
  27. INSERT INTO `provincias` VALUES (19,'Guadalajara');
  28. INSERT INTO `provincias` VALUES (20,'Guipuzcoa');
  29. INSERT INTO `provincias` VALUES (21,'Huelve');
  30. INSERT INTO `provincias` VALUES (22,'Huesca');
  31. INSERT INTO `provincias` VALUES (7,'Illes Baleares');
  32. INSERT INTO `provincias` VALUES (23,'Jaén');
  33. INSERT INTO `provincias` VALUES (26,'Rioja, La');
  34. INSERT INTO `provincias` VALUES (35,'Palmas, Las');
  35. INSERT INTO `provincias` VALUES (24,'León');
  36. INSERT INTO `provincias` VALUES (25,'Lleida');
  37. INSERT INTO `provincias` VALUES (27,'Lugo');
  38. INSERT INTO `provincias` VALUES (29,'Málaga');
  39. INSERT INTO `provincias` VALUES (28,'Madrid');
  40. INSERT INTO `provincias` VALUES (52,'Melilla');
  41. INSERT INTO `provincias` VALUES (30,'Murcia');
  42. INSERT INTO `provincias` VALUES (31,'Navarra');
  43. INSERT INTO `provincias` VALUES (32,'Ourense');
  44. INSERT INTO `provincias` VALUES (34,'Palencia');
  45. INSERT INTO `provincias` VALUES (36,'Pontevedra');
  46. INSERT INTO `provincias` VALUES (37,'Salamanca');
  47. INSERT INTO `provincias` VALUES (40,'Segovia');
  48. INSERT INTO `provincias` VALUES (41,'Sevilla');
  49. INSERT INTO `provincias` VALUES (42,'Soria');
  50. INSERT INTO `provincias` VALUES (38,'Santa Cruz de Tenerife');
  51. INSERT INTO `provincias` VALUES (43,'Tarragona');
  52. INSERT INTO `provincias` VALUES (44,'Teruel');
  53. INSERT INTO `provincias` VALUES (45,'Toledo');
  54. INSERT INTO `provincias` VALUES (46,'Valencia');
  55. INSERT INTO `provincias` VALUES (47,'Valladolid');
  56. INSERT INTO `provincias` VALUES (48,'Vizcaya');
  57. INSERT INTO `provincias` VALUES (49,'Zamora');
  58. INSERT INTO `provincias` VALUES (50,'Zaragoza');

Report this snippet  

You need to login to post a comment.