Importazione tabella province / regioni

Updated at: 23/01/2014

---

Per prima cosa creiamo la tabella:

CREATE TABLE `province` (
  `id_provincia` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) DEFAULT NULL,
  `valore` varchar(45) DEFAULT NULL,
  `regione` varchar(255) DEFAULT NULL,
  `ordine` int(10) unsigned NOT NULL DEFAULT '100',
  PRIMARY KEY (`id_provincia`)
)

Quindi importiamo tutte le voci:

INSERT INTO `province` VALUES 
(1,'Ancona','AN','Marche',100),
(2,'Macerata','MC','Marche',100),
(3,'Pesaro Urbino','PU','Marche',100),
(4,'Ascoli Piceno','AP','Marche',100),
(5,'Alessandria','AL','Piemonte',100),
(6,'Asti','AT','Piemonte',100),
(7,'Biella','BI','Piemonte',100),
(8,'Cuneo','CN','Piemonte',100),
(9,'Novara','NO','Piemonte',100),
(10,'Vercelli','VC','Piemonte',100),
(11,'Torino','TO','Piemonte',100),
(12,'Agrigento','AG','Sicilia',100),
(13,'Caltanissetta','CL','Sicilia',100),
(14,'Catania','CT','Sicilia',100),
(15,'Enna','EN','Sicilia',100),
(16,'Messina','ME','Sicilia',100),
(17,'Palermo','PA','Sicilia',100),
(18,'Ragusa','RG','Sicilia',100),
(19,'Siracusa','SR','Sicilia',100),
(20,'Trapani','TP','Sicilia',100),
(21,'Catanzaro','CZ','Calabria',100),
(22,'Cosenza','CS','Calabria',100),
(23,'Crotone','KR','Calabria',100),
(24,'Reggio Calabria','RC','Calabria',100),
(25,'Vibo Valentia','VV','Calabria',100),
(26,'Verbania','VB','Piemonte',100),
(27,'Matera','MT','Basilicata',100),
(28,'Potenza','PZ','Basilicata',100),
(29,'Bari','BA','Puglia',100),
(30,'Brindisi','BR','Puglia',100),
(31,'Foggia','FG','Puglia',100),
(32,'Lecce','LE','Puglia',100),
(33,'Taranto','TA','Puglia',100),
(34,'Avellino','AV','Campania',100),
(35,'Benevento','BN','Campania',100),
(36,'Caserta','CE','Campania',100),
(37,'Napoli','NA','Campania',100),
(38,'Salerno','SA','Campania',100),
(39,'Frosinone','FR','Lazio',100),
(40,'Latina','LT','Lazio',100),
(41,'Rieti','RI','Lazio',100),
(42,'Roma','RM','Lazio',100),
(43,'Viterbo','VT','Lazio',100),
(44,'Chieti','CH','Abruzzo',100),
(45,'L\'Aquila','AQ','Abruzzo',100),
(46,'Pescara','PE','Abruzzo',100),
(47,'Teramo','TE','Abruzzo',100),
(48,'Arezzo','AR','Toscana',100),
(49,'Firenze','FI','Toscana',100),
(50,'Grosseto','GR','Toscana',100),
(51,'Livorno','LI','Toscana',100),
(52,'Lucca','LU','Toscana',100),
(53,'Massa Carrara','MS','Toscana',100),
(54,'Pisa','PI','Toscana',100),
(55,'Pistoia','PT','Toscana',100),
(56,'Siena','SI','Toscana',100),
(57,'Bologna','BO','Emilia Romagna',100),
(58,'Ferrara','FE','Emilia Romagna',100),
(59,'Forli\' Cesena','FC','Emilia Romagna',100),
(60,'Modena','MO','Emilia Romagna',100),
(61,'Parma','PR','Emilia Romagna',100),
(62,'Piacenza','PC','Emilia Romagna',100),
(63,'Ravenna','RA','Emilia Romagna',100),
(64,'Reggio Emilia','RE','Emilia Romagna',100),
(65,'Rimini','RN','Emilia Romagna',100),
(66,'Belluno','BL','Veneto',100),
(67,'Padova','PD','Veneto',100),
(68,'Rovigo','RO','Veneto',100),
(69,'Treviso','TV','Veneto',100),
(70,'Venezia','VE','Veneto',100),
(71,'Verona','VR','Veneto',100),
(72,'Vicenza','VI','Veneto',100),
(73,'Gorizia','GO','Friuli Venezia Giulia',100),
(74,'Pordenone','PN','Friuli Venezia Giulia',100),
(75,'Udine','UD','Friuli Venezia Giulia',100),
(76,'Trieste','TS','Friuli Venezia Giulia',100),
(77,'Aosta','AO','Valle d'Aosta',100),
(78,'Cagliari','CA','Sardegna',100),
(79,'Nuoro','NU','Sardegna',100),
(80,'Oristano','OR','Sardegna',100),
(81,'Sassari','SS','Sardegna',100),
(82,'Genova','GE','Liguria',100),
(83,'Imperia','IM','Liguria',100),
(84,'Savona','SV','Liguria',100),
(85,'La Spezia','SP','Liguria',100),
(86,'Isernia','IS','Molise',100),
(87,'Campobasso','CB','Molise',100),
(88,'Perugia','PG','Umbria',100),
(89,'Terni','TR','Umbria',100),
(90,'Bergamo','BG','Lombardia',100),
(91,'Brescia','BS','Lombardia',100),
(92,'Como','CO','Lombardia',100),
(93,'Cremona','CR','Lombardia',100),
(94,'Lecco','LC','Lombardia',100),
(95,'Lodi','LO','Lombardia',100),
(96,'Mantova','MN','Lombardia',100),
(97,'Milano','MI','Lombardia',100),
(98,'Pavia','PV','Lombardia',100),
(99,'Sondrio','SO','Lombardia',100),
(100,'Varese','VA','Lombardia',100),
(101,'Trento','TN','Trentino Alto Adige',100),
(102,'Bolzano','BZ','Trentino Alto Adige',100),
(103,'Prato','PO','Toscana',100),
(104,'Carbonia Iglesias','CI','Sardegna',100),
(105,'Medio Campidano','VS','Sardegna',100),
(106,'Ogliastra','OG','Sardegna',100),
(107,'Olbia Tempio','OT','Sardegna',100),
(108,'Monza e Brianza','MB','Lombardia',100),
(109,'Fermo','FM','Marche',100),
(110,'Barletta-Andria-Trani','BT','Puglia',100),
(111,'Estero','EE','Estero',100);