{"id":20175,"date":"2022-12-02T06:51:00","date_gmt":"2022-12-02T05:51:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=20175"},"modified":"2023-01-03T12:08:42","modified_gmt":"2023-01-03T11:08:42","slug":"creer-et-modifier-une-table-mysql","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/","title":{"rendered":"Cr\u00e9er et modifier une table MySQL"},"content":{"rendered":"\n<h4 class=\"has-text-align-center wp-block-heading\"><strong><em>Comment cr\u00e9er, modifier et supprimer une table MySQL avec un script ? <\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL. MySQL est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle (SGBDR) qui permet de stocker et de g\u00e9rer des donn\u00e9es de mani\u00e8re organis\u00e9e. Dans ce tutoriel, nous allons donc voir comment cr\u00e9er une table, y ins\u00e9rer des donn\u00e9es, supprimer des donn\u00e9es, modifier la table pour ajouter ou supprimer des colonnes, vider toutes les donn\u00e9es de la table et supprimer la table.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#1-creer-une-table-mysql\" >1. Cr\u00e9er une table MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#2-inserer-des-donnees-dans-une-table\" >2. Ins\u00e9rer des donn\u00e9es dans une table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#3-supprimer-des-donnees-avec-mysql\" >3. Supprimer des donn\u00e9es avec MySQL<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#31-supprimer-toutes-les-donnees-dune-table\" >3.1 Supprimer toutes les donn\u00e9es d&rsquo;une table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#32-supprimer-certaines-donnees-dune-table\" >3.2 Supprimer certaines donn\u00e9es d&rsquo;une table<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#4-modifier-les-colonnes-avec-mysql\" >4. Modifier les colonnes avec MySQL<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#41-ajouter-une-colonne-mysql\" >4.1 Ajouter une colonne MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#42-supprimer-une-colonne-depuis-une-table-mysql\" >4.2 Supprimer une colonne depuis une table MySQL<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#5-vider-toutes-les-donnees-dune-table-mysql\" >5. Vider toutes les donn\u00e9es d&rsquo;une table MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#6-supprimer-une-table-mysql\" >6. Supprimer une table MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#7-conclusion-sur-les-requetes-pour-gerer-une-table-mysql\" >7. Conclusion sur les requ\u00eates pour g\u00e9rer une table MySQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-creer-une-table-mysql\"><span class=\"ez-toc-section\" id=\"1-creer-une-table-mysql\"><\/span>1. Cr\u00e9er une table MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour cr\u00e9er une table dans une base de donn\u00e9es MySQL, nous utilisons la commande <code>CREATE TABLE<\/code>. Voici un exemple de code qui cr\u00e9e une table nomm\u00e9e <code>users<\/code> avec deux colonnes, <code>id<\/code> et <code>username<\/code>, respectivement de type <code>INT<\/code> et <code>VARCHAR(255)<\/code>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE users (\n    id INT PRIMARY KEY AUTO_INCREMENT,\n    username VARCHAR(255)\n);\n<\/pre>\n\n\n\n<p>Nous pouvons \u00e9galement sp\u00e9cifier des contraintes pour chaque colonne. Par exemple, nous avons d\u00e9fini la colonne <code>id<\/code> comme \u00e9tant la cl\u00e9 primaire de la table et comme \u00e9tant un entier auto-incr\u00e9ment\u00e9.<\/p>\n\n\n\n<p>Pour v\u00e9rifier que la table a \u00e9t\u00e9 cr\u00e9\u00e9e avec succ\u00e8s, nous pouvons utiliser la commande MySQL <code>SHOW TABLES<\/code>, comme suit.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SHOW TABLES;\n<\/pre>\n\n\n\n<p>D&rsquo;autre part, suivre ce tutoriel plus d\u00e9taill\u00e9 pour <a href=\"https:\/\/expert-only.com\/en\/mysql\/create-table-mysql-with-primary-key\/\">cr\u00e9er une table MySQL avec une clef primaire<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-inserer-des-donnees-dans-une-table\"><\/span>2. Ins\u00e9rer des donn\u00e9es dans une table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour ins\u00e9rer des donn\u00e9es dans une table MySQL, nous utilisons la commande <code>INSERT INTO<\/code>. Voici un exemple de code qui ins\u00e8re un enregistrement dans la table <code>users<\/code> :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">INSERT INTO users (username) VALUES ('johndoe');\n<\/pre>\n\n\n\n<p>Nous pouvons \u00e9galement ins\u00e9rer plusieurs enregistrements en une seule fois en utilisant la syntaxe suivante :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">INSERT INTO users (username) VALUES ('johndoe'), ('janedoe');\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-supprimer-des-donnees-avec-mysql\"><\/span>3. Supprimer des donn\u00e9es avec MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour supprimer des donn\u00e9es d&rsquo;une table MySQL, nous utilisons la commande <code>DELETE FROM<\/code>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"31-supprimer-toutes-les-donnees-dune-table\"><\/span>3.1 Supprimer toutes les donn\u00e9es d&rsquo;une table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Voici un exemple de code qui supprime tous les enregistrements de la table <em>users<\/em>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DELETE FROM users;\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"32-supprimer-certaines-donnees-dune-table\"><\/span>3.2 Supprimer certaines donn\u00e9es d&rsquo;une table<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Nous pouvons \u00e9galement utiliser une clause `WHERE` pour sp\u00e9cifier des conditions de suppression. Par exemple, pour supprimer un enregistrement de la table `users` o\u00f9 le nom d&rsquo;utilisateur est `johndoe`, nous pouvons utiliser la requ\u00eate suivante.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DELETE FROM users WHERE username = 'johndoe';\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-modifier-les-colonnes-avec-mysql\"><\/span>4. Modifier les colonnes avec MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Il est possible de modifier une table MySQL en ajoutant ou en supprimant des colonnes. Pour ajouter une colonne, nous utilisons la commande `ALTER TABLE` avec l&rsquo;instruction `ADD COLUMN`.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"41-ajouter-une-colonne-mysql\"><\/span>4.1 Ajouter une colonne MySQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Voici un exemple de code qui ajoute une colonne `email` de type `VARCHAR(255)` \u00e0 la table `users` :<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER TABLE users ADD COLUMN email VARCHAR(255);\n<\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"42-supprimer-une-colonne-depuis-une-table-mysql\"><\/span>4.2 Supprimer une colonne depuis une table MySQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pour supprimer une colonne, nous utilisons \u00e9galement la commande `ALTER TABLE`, mais cette fois avec l&rsquo;instruction `DROP COLUMN`. Voici un exemple de code qui supprime la colonne `email` de la table <em>users<\/em>.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">ALTER TABLE users DROP COLUMN email;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-vider-toutes-les-donnees-dune-table-mysql\"><\/span>5. Vider toutes les donn\u00e9es d&rsquo;une table MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour vider toutes les donn\u00e9es d&rsquo;une table MySQL, nous pouvons utiliser la commande `TRUNCATE TABLE`. Cette commande supprime tous les enregistrements de la table et r\u00e9initialise l&rsquo;auto-incr\u00e9mentation de la cl\u00e9 primaire (s&rsquo;il y en a une). Voici un exemple de code qui vide la table `users`.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">TRUNCATE TABLE users;\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"6-supprimer-une-table-mysql\"><\/span>6. Supprimer une table MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Pour supprimer une table MySQL, nous utilisons la commande `DROP TABLE`. Cette commande supprime d\u00e9finitivement la table et toutes les donn\u00e9es qu&rsquo;elle contient. Voici un exemple de code qui supprime la table `users`.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">DROP TABLE users;\n<\/pre>\n\n\n\n<p>MySQL est Open Source et il est disponible au t\u00e9l\u00e9chargement depuis <a href=\"https:\/\/www.mysql.com\/fr\/downloads\/\" target=\"_blank\" rel=\"noreferrer noopener\">le site officiel mysql.com<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"7-conclusion-sur-les-requetes-pour-gerer-une-table-mysql\"><\/span>7. Conclusion sur les requ\u00eates pour g\u00e9rer une table MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Voil\u00e0, vous savez maintenant comment cr\u00e9er, modifier et supprimer une table MySQL, ainsi que comment ins\u00e9rer, supprimer et vider des donn\u00e9es de la table. N&rsquo;oubliez pas de toujours sauvegarder vos donn\u00e9es avant de effectuer des op\u00e9rations de modification ou de suppression, afin de pouvoir les r\u00e9cup\u00e9rer en cas de besoin.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"Vb8ELUKJm6\"><a href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-une-table-avec-mysql\/\">Cr\u00e9er une table avec MySQL et PHPMyAdmin<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Cr\u00e9er une table avec MySQL et PHPMyAdmin\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/mysql\/creer-une-table-avec-mysql\/embed\/#?secret=EiXnYHP79R#?secret=Vb8ELUKJm6\" data-secret=\"Vb8ELUKJm6\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment cr\u00e9er, modifier et supprimer une table MySQL avec un script ? Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL. MySQL est un syst\u00e8me de gestion de base de donn\u00e9es relationnelle (SGBDR) <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\" title=\"Cr\u00e9er et modifier une table MySQL\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10737,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[645],"tags":[],"class_list":{"0":"post-20175","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cr\u00e9er et modifier une table MySQL - Tables - MySQL<\/title>\n<meta name=\"description\" content=\"Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL, mais aussi afficher les tables de la base.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er et modifier une table MySQL\" \/>\n<meta property=\"og:description\" content=\"Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL, mais aussi afficher les tables de la base.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-02T05:51:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-03T11:08:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er et modifier une table MySQL\",\"datePublished\":\"2022-12-02T05:51:00+00:00\",\"dateModified\":\"2023-01-03T11:08:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\"},\"wordCount\":646,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg\",\"articleSection\":[\"MySQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\",\"url\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\",\"name\":\"Cr\u00e9er et modifier une table MySQL - Tables - MySQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg\",\"datePublished\":\"2022-12-02T05:51:00+00:00\",\"dateModified\":\"2023-01-03T11:08:42+00:00\",\"description\":\"Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL, mais aussi afficher les tables de la base.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er et modifier une table MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Cr\u00e9er et modifier une table MySQL - Tables - MySQL","description":"Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL, mais aussi afficher les tables de la base.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er et modifier une table MySQL","og_description":"Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL, mais aussi afficher les tables de la base.","og_url":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-12-02T05:51:00+00:00","article_modified_time":"2023-01-03T11:08:42+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er et modifier une table MySQL","datePublished":"2022-12-02T05:51:00+00:00","dateModified":"2023-01-03T11:08:42+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/"},"wordCount":646,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg","articleSection":["MySQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/","url":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/","name":"Cr\u00e9er et modifier une table MySQL - Tables - MySQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg","datePublished":"2022-12-02T05:51:00+00:00","dateModified":"2023-01-03T11:08:42+00:00","description":"Tutoriel pour apprendre \u00e0 cr\u00e9er, modifier, vider, et supprimer une table avec des scripts MySQL, mais aussi afficher les tables de la base.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/macro-1452986_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/mysql\/creer-et-modifier-une-table-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er et modifier une table MySQL"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/20175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=20175"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/20175\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10737"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=20175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=20175"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=20175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}