{"id":1094,"date":"2026-07-15T20:28:24","date_gmt":"2026-07-15T18:28:24","guid":{"rendered":"https:\/\/communaute-omr.fr\/?p=1094"},"modified":"2026-07-15T20:33:58","modified_gmt":"2026-07-15T18:33:58","slug":"creation-dune-base-de-donnees","status":"publish","type":"post","link":"https:\/\/communaute-omr.fr\/?p=1094","title":{"rendered":"Cr\u00e9ation d\u2019une base de donn\u00e9es"},"content":{"rendered":"\n<h1 id=\"but-de-larticle\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"But_de_larticle\"><\/span>But de l\u2019article<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons cr\u00e9er une base de donn\u00e9es qui contiendra une liste de villes avec leur code postal.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Le but n\u2019\u00e9tant pas de cr\u00e9er une application mais d\u2019avoir un cas d\u2019ecole simple avec 2 tables pour les jointures.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Pour cela nous allons cr\u00e9er&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Une base de donn\u00e9es carnet qui contiendra&nbsp;les tables :<\/li>\n\n\n\n<li>Codes postaux<\/li>\n\n\n\n<li>Ville<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Pour l\u2019\u00e9chantillonnage je me suis appuyer sur le r\u00e9f\u00e9rentiel officiel de l\u2019\u00e9tat <a href=\"https:\/\/www.data.gouv.fr\/api\/1\/datasets\/r\/008a2dda-2c60-4b63-b910-998f6f818089\">ici<\/a> <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Le but sera de pouvoir rechercher&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Une ville avec tous les codes postaux<\/li>\n\n\n\n<li>Un code postal avec toutes les villes<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Le sch\u00e9ma est tr\u00e8s simple&nbsp;:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/communaute-omr.fr\/wp-content\/uploads\/2026\/07\/image1-7.png\" alt=\"\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Un code postal peut avoir plusieurs villes<\/li>\n\n\n\n<li>Un nom de ville peut avoir plusieurs codes postaux<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Nous le verrons plus bas<\/p>\n\n\n\n<!--more-->\n\n\n\n<h1 id=\"creation-dune-base-de-donnees\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_dune_base_de_donnees\"><\/span>Cr\u00e9ation d\u2019une base de donn\u00e9es<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">Nous allons donc cr\u00e9er notre base de donn\u00e9es carnet via une commande de ouff&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>create database carnet\u00a0;<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">create<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">database<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #B392F0\">carnet<\/span><span style=\"color: #E1E4E8\">\u00a0;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">avec comme r\u00e9sultat&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>+--------------------+\n| Database           |\n+--------------------+\n| information_schema |\n| mysql              |\n| performance_schema |\n| sys                |\n| carnet             |\n+--------------------+\n5 rows in set (0.01 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #F97583\">Database<\/span><span style=\"color: #E1E4E8\">           |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| information_schema |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| mysql              |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| performance_schema |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| sys                |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| carnet             |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">--------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">5<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">01<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 id=\"creation-des-tables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Creation_des_tables\"><\/span>Cr\u00e9ation des tables<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"table-pour-les-codes-postaux\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Table_pour_les_codes_postaux\"><\/span>Table pour les codes postaux<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE `codepostal` (\n`cp_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identifiant unique pour les codes postaux',\n`Insee` varchar(200) DEFAULT NULL COMMENT 'Name of the host',\n`cp` varchar(200) DEFAULT NULL COMMENT 'Name of the host',\n`Acheminement` varchar(200) DEFAULT NULL COMMENT 'Name of the host',\nPRIMARY KEY (`cp_id`)\n)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TABLE<\/span><span style=\"color: #E1E4E8\"> `<\/span><span style=\"color: #B392F0\">codepostal<\/span><span style=\"color: #E1E4E8\">` (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">int<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">11<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">NOT NULL<\/span><span style=\"color: #E1E4E8\"> AUTO_INCREMENT COMMENT <\/span><span style=\"color: #9ECBFF\">&#39;Identifiant unique pour les codes postaux&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">200<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">DEFAULT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\"> COMMENT <\/span><span style=\"color: #9ECBFF\">&#39;Name of the host&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">200<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">DEFAULT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\"> COMMENT <\/span><span style=\"color: #9ECBFF\">&#39;Name of the host&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">200<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">DEFAULT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\"> COMMENT <\/span><span style=\"color: #9ECBFF\">&#39;Name of the host&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">PRIMARY KEY<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Les champs&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>cp_id&nbsp;: autoincr\u00e9ment de mysql ( Donc automatique et notre cl\u00e9 primaire)<\/li>\n\n\n\n<li>Insee&nbsp;: Code d\u2019index de r\u00e9f\u00e9rencement national<\/li>\n\n\n\n<li>cp&nbsp;: Le code postal<\/li>\n\n\n\n<li>Acheminement&nbsp;: centre de tri<\/li>\n<\/ul>\n\n\n\n<h2 id=\"table-pour-les-noms-de-villes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Table_pour_les_noms_de_villes\"><\/span>Table pour les noms de villes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>CREATE TABLE `ville` (\n`ville_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identifiant unique pour les villes',\n`cp_id` int(11) DEFAULT NULL COMMENT 'ID du code postal dans la table codepostal',\n`ville` varchar(200) DEFAULT NULL COMMENT 'Nom de la ville',\nUNIQUE KEY `cp_id` (`cp_id`,`ville_id`),\nKEY (`ville_id`)\n)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">CREATE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">TABLE<\/span><span style=\"color: #E1E4E8\"> `<\/span><span style=\"color: #B392F0\">ville<\/span><span style=\"color: #E1E4E8\">` (<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">`ville_id`<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">int<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">11<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">NOT NULL<\/span><span style=\"color: #E1E4E8\"> AUTO_INCREMENT COMMENT <\/span><span style=\"color: #9ECBFF\">&#39;Identifiant unique pour les villes&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">int<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">11<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">DEFAULT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\"> COMMENT <\/span><span style=\"color: #9ECBFF\">&#39;ID du code postal dans la table codepostal&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">varchar<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #79B8FF\">200<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">DEFAULT<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">NULL<\/span><span style=\"color: #E1E4E8\"> COMMENT <\/span><span style=\"color: #9ECBFF\">&#39;Nom de la ville&#39;<\/span><span style=\"color: #E1E4E8\">,<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">UNIQUE<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">KEY<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">,<\/span><span style=\"color: #9ECBFF\">`ville_id`<\/span><span style=\"color: #E1E4E8\">),<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">KEY<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`ville_id`<\/span><span style=\"color: #E1E4E8\">)<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Les champs&nbsp;:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ville_id&nbsp;: autoincr\u00e9ment de mysql ( Donc automatique et notre cl\u00e9 interne \u00e0 la table)<\/li>\n\n\n\n<li>Cp_id&nbsp;: Pour la jointure entre la table codepostal et ville<\/li>\n<\/ul>\n\n\n\n<h2 id=\"petit-controle\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Petit_controle\"><\/span>Petit contr\u00f4le<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 id=\"lister-les-tables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Lister_les_tables\"><\/span>Lister les tables&nbsp;:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>mysql> show tables;\n+------------------+\n| Tables_in_carnet |\n+------------------+\n| codepostal       |\n| ville            |\n+------------------+\n2 rows in set (0.00 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #E1E4E8\">mysql<\/span><span style=\"color: #F97583\">&gt;<\/span><span style=\"color: #E1E4E8\"> show tables;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| Tables_in_carnet |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| codepostal       |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| ville            |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">------------------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">2<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">rows<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">00<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h3 id=\"description-des-tables\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Description_des_tables\"><\/span>Description des tables<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Code postal<\/li>\n\n\n\n<li>Ville<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">On est plut\u00f4t bien l\u00e0, on est au top&nbsp;<\/p>\n\n\n\n<h1 id=\"inserons-des-lignes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Inserons_des_lignes\"><\/span>Ins\u00e9rons des lignes<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"table-des-cp\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Table_des_CP\"><\/span>Table des CP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Pour l\u2019exemple j\u2019ai import\u00e9 tout le fichier mais voici un extrait de l\u2019import&nbsp;:<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>INSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01001', '01400', 'L ABERGEMENT CLEMENCIAT');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01002', '01640', 'L ABERGEMENT DE VAREY');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01004', '01500', 'AMBERIEU EN BUGEY');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01005', '01330', 'AMBERIEUX EN DOMBES');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01006', '01300', 'AMBLEON');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01007', '01500', 'AMBRONAY');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01008', '01500', 'AMBUTRIX');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01009', '01300', 'ANDERT ET CONDON');\nINSERT INTO `codepostal` (`Insee`, `cp`, `Acheminement`) VALUES ('01010', '01350', 'ANGLEFORT');<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01001&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01400&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;L ABERGEMENT CLEMENCIAT&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01002&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01640&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;L ABERGEMENT DE VAREY&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01004&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01500&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;AMBERIEU EN BUGEY&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01005&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01330&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;AMBERIEUX EN DOMBES&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01006&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01300&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;AMBLEON&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01007&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01500&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;AMBRONAY&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01008&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01500&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;AMBUTRIX&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01009&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01300&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;ANDERT ET CONDON&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`codepostal`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`Insee`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`cp`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`Acheminement`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;01010&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;01350&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;ANGLEFORT&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"table-des-villes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Table_des_villes\"><\/span>Table des villes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">On fait de m\u00eame sans oublier l\u2019ID du code postal pour \u00e9viter les doublons<\/p>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>INSERT INTO `ville` (`cp_id`, `ville`) VALUES ('1', 'L Abergement Clemenciat');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('2', 'L Abergement De Varey');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('3', 'Amberieu En Bugey');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('4', 'Amberieux En Dombes');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('5', 'Ambleon');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('6', 'Ambronay');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('7', 'Ambutrix');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('8', 'Andert Et Condon');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('9', 'Anglefort');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('10', 'Apremont');\nINSERT INTO `ville` (`cp_id`, `ville`) VALUES ('11', 'Aranc');<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;1&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;L Abergement Clemenciat&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;2&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;L Abergement De Varey&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;3&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Amberieu En Bugey&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;4&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Amberieux En Dombes&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;5&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Ambleon&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;6&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Ambronay&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;7&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Ambutrix&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;8&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Andert Et Condon&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;9&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Anglefort&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;10&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Apremont&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">INSERT INTO<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">`cp_id`<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">`ville`<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">VALUES<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #9ECBFF\">&#39;11&#39;<\/span><span style=\"color: #E1E4E8\">, <\/span><span style=\"color: #9ECBFF\">&#39;Aranc&#39;<\/span><span style=\"color: #E1E4E8\">);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h1 id=\"petit-controle-des-imports\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Petit_controle_des_imports\"><\/span>Petit contr\u00f4le des imports&nbsp;:<span class=\"ez-toc-section-end\"><\/span><\/h1>\n\n\n\n<h2 id=\"les-codes-postaux\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Les_codes_postaux\"><\/span>Les codes postaux<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select count(*) from codepostal;\n+----------+\n| count(*) |\n+----------+\n|    35625 |\n+----------+\n1 row in set (0.01 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">count<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> codepostal;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">count<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\">) |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">35625<\/span><span style=\"color: #E1E4E8\"> |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">01<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<h2 id=\"les-villes\" class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Les_villes\"><\/span>Les villes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<div class=\"wp-block-kevinbatdorf-code-block-pro omr-terminal\" data-code-block-pro-font-family=\"Code-Pro-JetBrains-Mono\" style=\"font-size:.75rem;font-family:Code-Pro-JetBrains-Mono,ui-monospace,SFMono-Regular,Menlo,Monaco,Consolas,monospace;line-height:1rem;--cbp-tab-width:2;tab-size:var(--cbp-tab-width, 2)\"><span style=\"display:block;padding:16px 0 0 16px;margin-bottom:-1px;width:100%;text-align:left;background-color:#24292e\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"54\" height=\"14\" viewBox=\"0 0 54 14\"><g fill=\"none\" fill-rule=\"evenodd\" transform=\"translate(1 1)\"><circle cx=\"6\" cy=\"6\" r=\"6\" fill=\"#FF5F56\" stroke=\"#E0443E\" stroke-width=\".5\"><\/circle><circle cx=\"26\" cy=\"6\" r=\"6\" fill=\"#FFBD2E\" stroke=\"#DEA123\" stroke-width=\".5\"><\/circle><circle cx=\"46\" cy=\"6\" r=\"6\" fill=\"#27C93F\" stroke=\"#1AAB29\" stroke-width=\".5\"><\/circle><\/g><\/svg><\/span><span role=\"button\" tabindex=\"0\" style=\"color:#e1e4e8;display:none\" aria-label=\"Copy\" class=\"code-block-pro-copy-button\"><pre class=\"code-block-pro-copy-button-pre\" aria-hidden=\"true\"><textarea class=\"code-block-pro-copy-button-textarea\" tabindex=\"-1\" aria-hidden=\"true\" readonly>select count(*) from codepostal;\n+----------+\n| count(*) |\n+----------+\n|    35625 |\n+----------+\n1 row in set (0.01 sec)<\/textarea><\/pre><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" style=\"width:24px;height:24px\" fill=\"none\" viewBox=\"0 0 24 24\" stroke=\"currentColor\" stroke-width=\"2\"><path class=\"with-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2m-6 9l2 2 4-4\"><\/path><path class=\"without-check\" stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M9 5H7a2 2 0 00-2 2v12a2 2 0 002 2h10a2 2 0 002-2V7a2 2 0 00-2-2h-2M9 5a2 2 0 002 2h2a2 2 0 002-2M9 5a2 2 0 012-2h2a2 2 0 012 2\"><\/path><\/svg><\/span><pre class=\"shiki github-dark\" style=\"background-color: #24292e\" tabindex=\"0\"><code><span class=\"line\"><span style=\"color: #F97583\">select<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #79B8FF\">count<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\">) <\/span><span style=\"color: #F97583\">from<\/span><span style=\"color: #E1E4E8\"> codepostal;<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">| <\/span><span style=\"color: #79B8FF\">count<\/span><span style=\"color: #E1E4E8\">(<\/span><span style=\"color: #F97583\">*<\/span><span style=\"color: #E1E4E8\">) |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #E1E4E8\">|    <\/span><span style=\"color: #79B8FF\">35625<\/span><span style=\"color: #E1E4E8\"> |<\/span><\/span>\n<span class=\"line\"><span style=\"color: #F97583\">+<\/span><span style=\"color: #6A737D\">----------+<\/span><\/span>\n<span class=\"line\"><span style=\"color: #79B8FF\">1<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">row<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">in<\/span><span style=\"color: #E1E4E8\"> <\/span><span style=\"color: #F97583\">set<\/span><span style=\"color: #E1E4E8\"> (<\/span><span style=\"color: #79B8FF\">0<\/span><span style=\"color: #E1E4E8\">.<\/span><span style=\"color: #79B8FF\">01<\/span><span style=\"color: #E1E4E8\"> sec)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">M\u00eame nombre de lignes c\u2019est logique \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>But de l\u2019article Nous allons cr\u00e9er une base de donn\u00e9es qui contiendra une liste de villes avec leur code postal. Le but n\u2019\u00e9tant pas de cr\u00e9er une application mais d\u2019avoir un cas d\u2019ecole simple avec 2 tables pour les jointures. Pour cela nous allons cr\u00e9er&nbsp;: Pour l\u2019\u00e9chantillonnage je me suis appuyer sur le r\u00e9f\u00e9rentiel officiel de l\u2019\u00e9tat ici Le but sera de pouvoir rechercher&nbsp;: Le sch\u00e9ma est tr\u00e8s simple&nbsp;: Nous le verrons plus bas<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[34,35],"tags":[],"class_list":["post-1094","post","type-post","status-publish","format-standard","hentry","category-base-de-donnees","category-mysql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"admin","author_link":"https:\/\/communaute-omr.fr\/?author=1"},"uagb_comment_info":0,"uagb_excerpt":"But de l\u2019article Nous allons cr\u00e9er une base de donn\u00e9es qui contiendra une liste de villes avec leur code postal. Le but n\u2019\u00e9tant pas de cr\u00e9er une application mais d\u2019avoir un cas d\u2019ecole simple avec 2 tables pour les jointures. Pour cela nous allons cr\u00e9er&nbsp;: Pour l\u2019\u00e9chantillonnage je me suis appuyer sur le r\u00e9f\u00e9rentiel officiel\u2026","_links":{"self":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1094","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1094"}],"version-history":[{"count":4,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1094\/revisions"}],"predecessor-version":[{"id":1100,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=\/wp\/v2\/posts\/1094\/revisions\/1100"}],"wp:attachment":[{"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/communaute-omr.fr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}