Skip to content

Instantly share code, notes, and snippets.

@vlepeule

vlepeule/query.sql

Last active April 19, 2016 12:45
Show Gist options
  • Save vlepeule/e2f817d424527b45e0871b0d4e3a912e to your computer and use it in GitHub Desktop.
Save vlepeule/e2f817d424527b45e0871b0d4e3a912e to your computer and use it in GitHub Desktop.
Download ZIP
Mettre à jour les anciennes regions françaises dans une base de données
Raw
query.sql
UPDATE `table_concernee` SET `colonne_region` = 'Centre-Val de Loire' WHERE `region` = 'Centre';
UPDATE `table_concernee` SET `colonne_region` = 'Bourgogne Franche-Comté' WHERE `region` = 'Bourgogne';
UPDATE `table_concernee` SET `colonne_region` = 'Bourgogne Franche-Comté' WHERE `region` = 'Franche-Comté';
UPDATE `table_concernee` SET `colonne_region` = 'Normandie' WHERE `region` = 'Haute-Normandie';
UPDATE `table_concernee` SET `colonne_region` = 'Normandie' WHERE `region` = 'Basse-Normandie';
UPDATE `table_concernee` SET `colonne_region` = 'Nord-Pas-de-Calais Picardie' WHERE `region` = 'Nord-Pas-de-Calais';
UPDATE `table_concernee` SET `colonne_region` = 'Nord-Pas-de-Calais Picardie' WHERE `region` = 'Picardie';
UPDATE `table_concernee` SET `colonne_region` = 'Alsace-Champagne-Ardenne-Lorraine' WHERE `region` = 'Lorraine';
UPDATE `table_concernee` SET `colonne_region` = 'Alsace-Champagne-Ardenne-Lorraine' WHERE `region` = 'Alsace';
UPDATE `table_concernee` SET `colonne_region` = 'Alsace-Champagne-Ardenne-Lorraine' WHERE `region` = 'Champagne-Ardenne';
UPDATE `table_concernee` SET `colonne_region` = 'Aquitaine Limousin Poitou-Charentes' WHERE `region` = 'Aquitaine';
UPDATE `table_concernee` SET `colonne_region` = 'Aquitaine Limousin Poitou-Charentes' WHERE `region` = 'Poitou-Charentes';
UPDATE `table_concernee` SET `colonne_region` = 'Aquitaine Limousin Poitou-Charentes' WHERE `region` = 'Limousin';
UPDATE `table_concernee` SET `colonne_region` = 'Languedoc-Roussillon Midi-Pyrénées' WHERE `region` = 'Midi-Pyrénées';
UPDATE `table_concernee` SET `colonne_region` = 'Languedoc-Roussillon Midi-Pyrénées' WHERE `region` = 'Languedoc-Roussillon';
UPDATE `table_concernee` SET `colonne_region` = 'Auvergne Rhône-Alpes' WHERE `region` = 'Rhône-Alpes';
UPDATE `table_concernee` SET `colonne_region` = 'Auvergne Rhône-Alpes' WHERE `region` = 'Auvergne';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment