{"id":199673,"date":"2023-06-02T07:00:00","date_gmt":"2023-06-02T07:00:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=199673"},"modified":"2023-11-09T13:52:15","modified_gmt":"2023-11-09T13:52:15","slug":"sql-delete-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/sql-delete-tout-savoir","title":{"rendered":"SQL DELETE : Comment utiliser cette requ\u00eate ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"199673\" class=\"elementor elementor-199673\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-02502bf e-flex e-con-boxed e-con\" data-id=\"02502bf\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b5f0906 elementor-widget elementor-widget-heading\" data-id=\"b5f0906\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Parmi les requ\u00eates incontournables du langage SQL, il y a DELETE. Et pour cause, cette commande vous permet de supprimer des lignes de donn\u00e9es. Mais comment utiliser SQL DELETE ? C\u2019est ce que nous allons voir dans cet article.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-96dcd70 e-flex e-con-boxed e-con\" data-id=\"96dcd70\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-fa83a5e elementor-widget elementor-widget-heading\" data-id=\"fa83a5e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Qu'est-ce que SQL DELETE ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2c66d97 elementor-widget elementor-widget-text-editor\" data-id=\"2c66d97\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>Afin de garantir la qualit\u00e9 et la fiabilit\u00e9 des donn\u00e9es d\u2019une table, il faut souvent <strong>supprimer une ou plusieurs donn\u00e9es<\/strong> (soient parce qu\u2019elles sont fausses, obsol\u00e8tes, erron\u00e9es, inad\u00e9quates, \u2026). \u00c0 cette fin, il est possible d\u2019utiliser la <strong>requ\u00eate SQL DELETE<\/strong>. Cette commande vous permet de supprimer tous les enregistrements dont vous n\u2019avez plus besoin.<\/p><p><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir<\/strong> <\/span>: avant de r\u00e9aliser la moindre suppression sur une base de donn\u00e9es ou une table, nous vous conseillons d\u2019effectuer une sauvegarde. Une fois que la requ\u00eate DELETE est lanc\u00e9e, il n\u2019est plus possible de revenir en arri\u00e8re. Alors si vous souhaitez r\u00e9cup\u00e9rer les donn\u00e9es effac\u00e9es par m\u00e9garde, mieux vaut disposer d\u2019un backup.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-85a6d98 e-flex e-con-boxed e-con\" data-id=\"85a6d98\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f8e9d67 elementor-widget elementor-widget-heading\" data-id=\"f8e9d67\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment utiliser SQL DELETE pour supprimer des donn\u00e9es ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4809eda elementor-widget elementor-widget-text-editor\" data-id=\"4809eda\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>La syntaxe pour supprimer des donn\u00e9es dans une table est la suivante :<\/p><p style=\"padding-left: 40px;\">DELETE FROM `table`<br \/>WHERE condition<\/p><p>Et pour vous aider \u00e0 mieux comprendre l\u2019utilisation de SQL DELETE, nous vous proposons plusieurs cas d\u2019applications concrets. \u00c0 cette fin, nous utilisons le tableau \u00ab\u00a0Client\u00a0\u00bb ci-dessous :<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c8b5cd elementor-widget elementor-widget-html\" data-id=\"1c8b5cd\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">ID<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-mw77\">\u00c2ge<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-8806\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-baqh\">29<\/td>\r\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-8806\">2<\/td>\r\n    <td class=\"tg-c3ow\">Thomas <\/td>\r\n    <td class=\"tg-c3ow\">Durant<\/td>\r\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\r\n    <td class=\"tg-baqh\">35<\/td>\r\n    <td class=\"tg-baqh\">tomtom@sfr.fr<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-mw77\">3<\/td>\r\n    <td class=\"tg-baqh\">Marie<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n    <td class=\"tg-baqh\">Angers<\/td>\r\n    <td class=\"tg-baqh\">27<\/td>\r\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-mw77\">4<\/td>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n    <td class=\"tg-baqh\">Marseille<\/td>\r\n    <td class=\"tg-baqh\">32<\/td>\r\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bb7965e elementor-widget elementor-widget-heading\" data-id=\"bb7965e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Supprimer une seule ligne<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a06443 elementor-widget elementor-widget-text-editor\" data-id=\"4a06443\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Si vous souhaitez supprimer une seule ligne, il vous suffit d\u2019enregistrer la requ\u00eate suivante : <\/p><p style=\"padding-left: 40px;\">DELETE FROM `Client`<br \/>WHERE `id` = 2<\/p><p>Dans ce cadre, nous avons supprim\u00e9 la ligne du tableau Client correspondant \u00e0 l\u2019ID 2. Voici le r\u00e9sultat :<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-62da8f5 elementor-widget elementor-widget-html\" data-id=\"62da8f5\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">ID<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-mw77\">\u00c2ge<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-8806\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-baqh\">29<\/td>\r\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-mw77\">3<\/td>\r\n    <td class=\"tg-baqh\">Marie<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n    <td class=\"tg-baqh\">Angers<\/td>\r\n    <td class=\"tg-baqh\">27<\/td>\r\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-mw77\">4<\/td>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n    <td class=\"tg-baqh\">Marseille<\/td>\r\n    <td class=\"tg-baqh\">32<\/td>\r\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0eccc5e elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"0eccc5e\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 utiliser SQL DELETE<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-53d8d35 elementor-widget elementor-widget-heading\" data-id=\"53d8d35\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Supprimer plusieurs lignes<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-abe32dd elementor-widget elementor-widget-text-editor\" data-id=\"abe32dd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Vous pouvez supprimer plusieurs lignes facilement d\u00e8s lors qu\u2019elles pr\u00e9sentent des caract\u00e9ristiques communes. <\/p><p>Par exemple, supprimer tous les clients de plus de 30 ans. <\/p><p>Voici la requ\u00eate : <\/p><p style=\"padding-left: 40px;\">DELETE FROM `Client`<br \/>WHERE ` ge` &gt; &rsquo;30&rsquo;<\/p><p>Et le r\u00e9sultat : <\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d21b5b8 elementor-widget elementor-widget-html\" data-id=\"d21b5b8\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">ID<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-mw77\">\u00c2ge<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-8806\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-baqh\">29<\/td>\r\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-mw77\">3<\/td>\r\n    <td class=\"tg-baqh\">Marie<\/td>\r\n    <td class=\"tg-baqh\">Leroy<\/td>\r\n    <td class=\"tg-baqh\">Angers<\/td>\r\n    <td class=\"tg-baqh\">27<\/td>\r\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2a9999a elementor-widget elementor-widget-text-editor\" data-id=\"2a9999a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Pour rappel, la <strong>clause WHERE<\/strong> vous permet de sp\u00e9cifier les lignes de la table que vous souhaitez supprimer.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02d012c elementor-widget elementor-widget-heading\" data-id=\"02d012c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Supprimer toutes les donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-710bb7b elementor-widget elementor-widget-text-editor\" data-id=\"710bb7b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>La syntaxe est la suivante :<\/p><p style=\"padding-left: 40px;\">DELETE FROM `tableau`<\/p><p>Il suffit d\u2019enlever la clause conditionnelle WHERE pour supprimer toutes les donn\u00e9es de votre tableau.<\/p><p><span style=\"text-decoration: underline;\"><strong>Bon \u00e0 savoir :<\/strong><\/span> \u00e0 la place de la requ\u00eate DELETE, il est aussi possible d\u2019utiliser la <strong>commande TRUNCATE<\/strong>. Le fonctionnement est identique, \u00e0 une diff\u00e9rence pr\u00e8s : s\u2019il y a un auto-incr\u00e9ment, la requ\u00eate TRUNCATE le r\u00e9initialise. Ce qui n\u2019est pas le cas de la commande DELETE.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-aad02be elementor-widget elementor-widget-heading\" data-id=\"aad02be\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Supprimer les lignes entre deux jeux de donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-50863f4 elementor-widget elementor-widget-text-editor\" data-id=\"50863f4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Il est possible d\u2019utiliser la requ\u00eate DELETE avec d\u2019autres commandes SQL. Dans cet exemple, nous vous pr\u00e9sentons \u00e9galement les requ\u00eates BETWEEN et AND. L\u2019id\u00e9e est alors de supprimer les lignes entre deux autres lignes. Par exemple, entre les lignes 1 et 4. <\/p><p>La syntaxe est la suivante : <\/p><p style=\"padding-left: 40px;\">DELETE FROM Client WHERE id BETWEEN 1 AND 4.<\/p><p>Voici le r\u00e9sultat : <\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02abe63 elementor-widget elementor-widget-html\" data-id=\"02abe63\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style type=\"text\/css\">\r\n.tg  {border-collapse:collapse;border-spacing:0;}\r\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\r\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\r\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\r\n.tg .tg-baqh{text-align:center;vertical-align:top}\r\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\r\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\r\n<\/style>\r\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\r\n<colgroup>\r\n<col style=\"width: 25px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 125px\">\r\n<col style=\"width: 100px\">\r\n<col style=\"width: 200px\">\r\n<\/colgroup>\r\n<thead>\r\n  <tr>\r\n    <th class=\"tg-8806\">ID<\/th>\r\n    <th class=\"tg-8806\">Pr\u00e9nom<\/th>\r\n    <th class=\"tg-8806\">Nom<\/th>\r\n    <th class=\"tg-8806\">Ville<\/th>\r\n    <th class=\"tg-mw77\">\u00c2ge<\/th>\r\n    <th class=\"tg-mw77\">Email<\/th>\r\n  <\/tr>\r\n<\/thead>\r\n<tbody>\r\n  <tr>\r\n    <td class=\"tg-8806\">1<\/td>\r\n    <td class=\"tg-c3ow\">Justin<\/td>\r\n    <td class=\"tg-c3ow\">Martin<\/td>\r\n    <td class=\"tg-c3ow\">Paris<\/td>\r\n    <td class=\"tg-baqh\">29<\/td>\r\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\r\n  <\/tr>\r\n  <tr>\r\n    <td class=\"tg-mw77\">4<\/td>\r\n    <td class=\"tg-baqh\">Vanessa<\/td>\r\n    <td class=\"tg-baqh\">Savary<\/td>\r\n    <td class=\"tg-baqh\">Marseille<\/td>\r\n    <td class=\"tg-baqh\">32<\/td>\r\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/td>\r\n  <\/tr>\r\n<\/tbody>\r\n<\/table>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd12300 elementor-widget elementor-widget-text-editor\" data-id=\"cd12300\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Il ne s\u2019agit l\u00e0 que de quelques exemples simplifi\u00e9s. En r\u00e9alit\u00e9, il existe de <strong>nombreuses applications de la commande SQL DELETE<\/strong>. Si vous souhaitez approfondir, n\u2019h\u00e9sitez pas \u00e0 rejoindre notre formation.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5f8a243 e-flex e-con-boxed e-con\" data-id=\"5f8a243\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bbb5f4f elementor-widget elementor-widget-heading\" data-id=\"bbb5f4f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Rejoignez la formation DataScientest pour approfondir le langage SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-04a1ffb elementor-widget elementor-widget-text-editor\" data-id=\"04a1ffb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>La <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">ma\u00eetrise du langage SQL<\/a> est l\u2019un des fondamentaux de tout expert de la donn\u00e9es ou d\u00e9veloppeurs. Mais entre les mises \u00e0 jour, les suppressions, les ajouts\u2026 il est n\u00e9cessaire de conna\u00eetre une multitude de requ\u00eates SQL. <br \/>C\u2019est pourquoi, nous vous proposons des formations chez DataScientest. En plus de la commande SQL DELETE, vous d\u00e9couvrirez toutes les requ\u00eates indispensables \u00e0 la manipulation d\u2019une <a href=\"https:\/\/datascientest.com\/bases-de-donnees-relationnelles\">base de donn\u00e9es relationnelles<\/a>.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e59b9a6 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e59b9a6\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir les formations de DataScientest<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cc9616e e-flex e-con-boxed e-con\" data-id=\"cc9616e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-33b3341 elementor-widget elementor-widget-html\" data-id=\"33b3341\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu'est-ce que SQL DELETE ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Afin de garantir la qualit\u00e9 et la fiabilit\u00e9 des donn\u00e9es d\u2019une table, il faut souvent supprimer une ou plusieurs donn\u00e9es (soient parce qu\u2019elles sont fausses, obsol\u00e8tes, erron\u00e9es, inad\u00e9quates, \u2026). \u00c0 cette fin, il est possible d\u2019utiliser la requ\u00eate SQL DELETE. Cette commande vous permet de supprimer tous les enregistrements dont vous n\u2019avez plus besoin.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Supprimer les lignes entre deux jeux de donn\u00e9es\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Il est possible d\u2019utiliser la requ\u00eate DELETE avec d\u2019autres commandes SQL. Dans cet exemple, nous vous pr\u00e9sentons \u00e9galement les requ\u00eates BETWEEN et AND. L\u2019id\u00e9e est alors de supprimer les lignes entre deux autres lignes. Par exemple, entre les lignes 1 et 4.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Parmi les requ\u00eates incontournables du langage SQL, il y a DELETE. Et pour cause, cette commande vous permet de supprimer des lignes de donn\u00e9es. Mais comment utiliser SQL DELETE ? C\u2019est ce que nous allons voir dans cet article. Qu&rsquo;est-ce que SQL DELETE ? Afin de garantir la qualit\u00e9 et la fiabilit\u00e9 des donn\u00e9es d\u2019une [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":199693,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL DELETE : Comment utiliser cette requ\u00eate ? | DataScientest<\/title>\n<meta name=\"description\" content=\"Afin de garantir la qualit\u00e9 et la fiabilit\u00e9 des donn\u00e9es d\u2019une table, il y a la commande SQL DELETE. Focus.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/sql-delete-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL DELETE : Comment utiliser cette requ\u00eate ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/sql-delete-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-02T07:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:52:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/delete-sql-datascientest.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/sql-delete-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/sql-delete-tout-savoir\",\"name\":\"SQL DELETE : Comment utiliser cette requ\u00eate ? | DataScientest\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-06-02T07:00:00+00:00\",\"dateModified\":\"2023-11-09T13:52:15+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"Afin de garantir la qualit\u00e9 et la fiabilit\u00e9 des donn\u00e9es d\u2019une table, il y a la commande SQL DELETE. Focus.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/sql-delete-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL DELETE : Comment utiliser cette requ\u00eate ? | DataScientest","description":"Afin de garantir la qualit\u00e9 et la fiabilit\u00e9 des donn\u00e9es d\u2019une table, il y a la commande SQL DELETE. Focus.","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:\/\/datascientest.com\/sql-delete-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"SQL DELETE : Comment utiliser cette requ\u00eate ?","og_url":"https:\/\/datascientest.com\/sql-delete-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-06-02T07:00:00+00:00","article_modified_time":"2023-11-09T13:52:15+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/05\/delete-sql-datascientest.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/sql-delete-tout-savoir","url":"https:\/\/datascientest.com\/sql-delete-tout-savoir","name":"SQL DELETE : Comment utiliser cette requ\u00eate ? | DataScientest","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-06-02T07:00:00+00:00","dateModified":"2023-11-09T13:52:15+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"Afin de garantir la qualit\u00e9 et la fiabilit\u00e9 des donn\u00e9es d\u2019une table, il y a la commande SQL DELETE. Focus.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/sql-delete-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/199673"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=199673"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/199673\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/199693"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=199673"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=199673"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=199673"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}