{"id":171940,"date":"2023-10-15T05:54:32","date_gmt":"2023-10-15T04:54:32","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=171940"},"modified":"2023-10-15T08:21:05","modified_gmt":"2023-10-15T07:21:05","slug":"sql-delete-how-do-i-use-this-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query","title":{"rendered":"SQL DELETE: How do I use this query?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"171940\" class=\"elementor elementor-171940\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-80744e8 e-flex e-con-boxed e-con\" data-id=\"80744e8\" 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-4bb28c7 elementor-widget elementor-widget-heading\" data-id=\"4bb28c7\" 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\">One of the must-have SQL queries is DELETE. And with good reason: this command lets you delete rows of data. But how do you use SQL DELETE? Let's find out in this article.\n<\/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-3648eca e-flex e-con-boxed e-con\" data-id=\"3648eca\" 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-9ddb38d elementor-widget elementor-widget-heading\" data-id=\"9ddb38d\" 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\">What is SQL DELETE?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6d0483c elementor-widget elementor-widget-text-editor\" data-id=\"6d0483c\" 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>To guarantee the quality and reliability of the data in a table, it is often necessary to delete one or more items of data (either because they are false, obsolete, erroneous, inadequate, etc.). To this end, you can use the <a href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\">SQL<\/a> DELETE query. This command allows you to delete all records you no longer need.<\/p><p>Good to know: before deleting anything from a database or table, we recommend that you perform a backup. Once a DELETE request has been launched, there&#8217;s no going back. So if you want to recover data that has been inadvertently deleted, it&#8217;s best to have a 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-26b63a3 e-flex e-con-boxed e-con\" data-id=\"26b63a3\" 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-8530648 elementor-widget elementor-widget-heading\" data-id=\"8530648\" 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\">How do I use SQL DELETE to delete data?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79d1966 elementor-widget elementor-widget-text-editor\" data-id=\"79d1966\" 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>The syntax for deleting data from a table is as follows:<\/p><p>DELETE FROM `table`<br \/>WHERE condition<\/p><p>And to help you better understand the use of SQL DELETE, we&#8217;ve put together a number of concrete application cases. To this end, we use the &#8220;Client&#8221; table below:<\/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-b48df24 elementor-widget elementor-widget-html\" data-id=\"b48df24\" 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\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">ID<\/th>\n    <th class=\"tg-8806\">Vorname<\/th>\n    <th class=\"tg-8806\">Nachname<\/th>\n    <th class=\"tg-8806\">Stadt<\/th>\n    <th class=\"tg-mw77\">Alter<\/th>\n    <th class=\"tg-mw77\">E-Mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-8806\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Paris<\/td>\n    <td class=\"tg-baqh\">29<\/td>\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-8806\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas <\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\n    <td class=\"tg-baqh\">35<\/td>\n    <td class=\"tg-baqh\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-mw77\">3<\/td>\n    <td class=\"tg-baqh\">Marie<\/td>\n    <td class=\"tg-baqh\">Leroy<\/td>\n    <td class=\"tg-baqh\">Angers<\/td>\n    <td class=\"tg-baqh\">27<\/td>\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-mw77\">4<\/td>\n    <td class=\"tg-baqh\">Vanessa<\/td>\n    <td class=\"tg-baqh\">Savary<\/td>\n    <td class=\"tg-baqh\">Marseille<\/td>\n    <td class=\"tg-baqh\">32<\/td>\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8a705c1 elementor-widget elementor-widget-heading\" data-id=\"8a705c1\" 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\">Delete a single line<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a9ba2fd elementor-widget elementor-widget-text-editor\" data-id=\"a9ba2fd\" 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>If you wish to delete a single line, simply register the following query:<\/p><p>DELETE FROM `Client`<br \/>WHERE `id` = 2<\/p><p>In this example, we&#8217;ve deleted the row in the Customer table corresponding to ID 2. Here&#8217;s the result:<\/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-16c4928 elementor-widget elementor-widget-html\" data-id=\"16c4928\" 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\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">ID<\/th>\n    <th class=\"tg-8806\">Vorname<\/th>\n    <th class=\"tg-8806\">Nachname<\/th>\n    <th class=\"tg-8806\">Stadt<\/th>\n    <th class=\"tg-mw77\">Alter<\/th>\n    <th class=\"tg-mw77\">E-Mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-8806\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Paris<\/td>\n    <td class=\"tg-baqh\">29<\/td>\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-8806\">2<\/td>\n    <td class=\"tg-c3ow\">Thomas <\/td>\n    <td class=\"tg-c3ow\">Durant<\/td>\n    <td class=\"tg-c3ow\">Bordeaux<\/td>\n    <td class=\"tg-baqh\">35<\/td>\n    <td class=\"tg-baqh\">tomtom@sfr.fr<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-mw77\">3<\/td>\n    <td class=\"tg-baqh\">Marie<\/td>\n    <td class=\"tg-baqh\">Leroy<\/td>\n    <td class=\"tg-baqh\">Angers<\/td>\n    <td class=\"tg-baqh\">27<\/td>\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-mw77\">4<\/td>\n    <td class=\"tg-baqh\">Vanessa<\/td>\n    <td class=\"tg-baqh\">Savary<\/td>\n    <td class=\"tg-baqh\">Marseille<\/td>\n    <td class=\"tg-baqh\">32<\/td>\n    <td class=\"tg-baqh\">vanessa13@gmail.com<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f3cae1 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4f3cae1\" 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\/en\/data-courses\">\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\">Learn how to use 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-f6bc06e elementor-widget elementor-widget-heading\" data-id=\"f6bc06e\" 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\">Delete several lines<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f84d39 elementor-widget elementor-widget-text-editor\" data-id=\"6f84d39\" 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>You can easily delete several lines if they have common characteristics.<\/p><p>For example, delete all customers over 30 years old.<\/p><p>Here&#8217;s the query:<\/p><p>DELETE FROM `Customer`<br \/>WHERE ` ge` &gt; &#8217;30&#8217;<\/p><p>And the result:<\/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-e498acc elementor-widget elementor-widget-html\" data-id=\"e498acc\" 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\">\n.tg  {border-collapse:collapse;border-spacing:0;}\n.tg td{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg th{border-color:black;border-style:solid;border-width:1px;font-family:Arial, sans-serif;font-size:14px;\n  font-weight:normal;overflow:hidden;padding:10px 5px;word-break:normal;}\n.tg .tg-8806{background-color:#6434fc;border-color:inherit;color:#efefef;text-align:center;vertical-align:top}\n.tg .tg-baqh{text-align:center;vertical-align:top}\n.tg .tg-c3ow{border-color:inherit;text-align:center;vertical-align:top}\n.tg .tg-mw77{background-color:#6434fc;color:#efefef;text-align:center;vertical-align:top}\n<\/style>\n<table class=\"tg\" style=\"undefined;table-layout: fixed; width: 700px\">\n<colgroup>\n<col style=\"width: 25px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 125px\">\n<col style=\"width: 100px\">\n<col style=\"width: 200px\">\n<\/colgroup>\n<thead>\n  <tr>\n    <th class=\"tg-8806\">ID<\/th>\n    <th class=\"tg-8806\">Vorname<\/th>\n    <th class=\"tg-8806\">Nachname<\/th>\n    <th class=\"tg-8806\">Stadt<\/th>\n    <th class=\"tg-mw77\">Alter<\/th>\n    <th class=\"tg-mw77\">E-Mail<\/th>\n  <\/tr>\n<\/thead>\n<tbody>\n  <tr>\n    <td class=\"tg-8806\">1<\/td>\n    <td class=\"tg-c3ow\">Justin<\/td>\n    <td class=\"tg-c3ow\">Martin<\/td>\n    <td class=\"tg-c3ow\">Paris<\/td>\n    <td class=\"tg-baqh\">29<\/td>\n    <td class=\"tg-baqh\">justinemartin@gmail.com<\/td>\n  <\/tr>\n  <tr>\n    <td class=\"tg-mw77\">3<\/td>\n    <td class=\"tg-baqh\">Marie<\/td>\n    <td class=\"tg-baqh\">Leroy<\/td>\n    <td class=\"tg-baqh\">Angers<\/td>\n    <td class=\"tg-baqh\">27<\/td>\n    <td class=\"tg-baqh\">marieleroy@laposte.net<\/td>\n  <\/tr>\n<\/tbody>\n<\/table>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c1a9213 elementor-widget elementor-widget-text-editor\" data-id=\"c1a9213\" 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>As a reminder, the WHERE clause allows you to specify the table rows you wish to 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-facbb6a elementor-widget elementor-widget-heading\" data-id=\"facbb6a\" 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\">Delete all data<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cc68589 elementor-widget elementor-widget-text-editor\" data-id=\"cc68589\" 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>The syntax is as follows:<\/p><p>DELETE FROM `tableau`<\/p><p>Simply remove the WHERE conditional clause to remove all data from your table.<\/p><p>Good to know: instead of the DELETE request, you can also use the TRUNCATE command. The operation is identical, with one difference: if there is an auto-increment, the TRUNCATE query resets it. This is not the case with the DELETE command.<\/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-2949e6b elementor-widget elementor-widget-heading\" data-id=\"2949e6b\" 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\">Delete rows between two datasets<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-22ae6e9 elementor-widget elementor-widget-text-editor\" data-id=\"22ae6e9\" 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>The DELETE query can be used in conjunction with <a href=\"https:\/\/datascientest.com\/en\/sql-developer-what-is-it-whats-it-for\">other SQL commands<\/a>. In this example, we also show you the BETWEEN and AND queries. The idea is to delete the lines between two other lines. For example, between lines 1 and 4.<\/p><p>The syntax is as follows<\/p><p>DELETE FROM Client WHERE id BETWEEN 1 AND 4.<\/p><p>Here&#8217;s the result:<\/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-dee2d68 elementor-widget elementor-widget-html\" data-id=\"dee2d68\" 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-317b8ce elementor-widget elementor-widget-text-editor\" data-id=\"317b8ce\" 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>These are just a few simplified examples. In reality, the SQL DELETE command has many applications. If you&#8217;d like to learn more, join our training program.<\/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-e7814e7 e-flex e-con-boxed e-con\" data-id=\"e7814e7\" 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-3e2c78d elementor-widget elementor-widget-heading\" data-id=\"3e2c78d\" 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\">Join the DataScientest training course to learn more about SQL language<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e72ce77 elementor-widget elementor-widget-text-editor\" data-id=\"e72ce77\" 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><a href=\"https:\/\/datascientest.com\/en\/sql-joins-everything-you-need-to-know-about\">Mastering SQL is one of the fundamentals<\/a> for any data expert or developer. But between updates, deletions, additions&#8230; you need to know a multitude of SQL queries.<br \/>That&#8217;s why we offer training courses at DataScientest. In addition to the <a href=\"https:\/\/datascientest.com\/en\/all-about-non-relational-databases\">SQL DELETE<\/a> command, you&#8217;ll learn all the queries that are essential for handling a relational database.<\/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-10d0acc elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"10d0acc\" 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\/en\/data-courses\">\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\">Discover DataScientest's training courses<\/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\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>One of the must-have SQL queries is DELETE. And with good reason: this command lets you delete rows of data. But how do you use SQL DELETE? Let&#8217;s find out in this article. What is SQL DELETE? To guarantee the quality and reliability of the data in a table, it is often necessary to delete [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":171942,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2425],"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: How do I use this query?<\/title>\n<meta name=\"description\" content=\"Learn how to effectively utilize SQL DELETE queries to remove specific data from your database. Explore the syntax, examples, and best practices for managing and maintaining your SQL databases.\" \/>\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\/en\/sql-delete-how-do-i-use-this-query\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL DELETE: How do I use this query?\" \/>\n<meta property=\"og:description\" content=\"One of the must-have SQL queries is DELETE. And with good reason: this command lets you delete rows of data. But how do you use SQL DELETE? Let&#039;s find out\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\" \/>\n<meta property=\"og:site_name\" content=\"DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-15T04:54:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-15T07:21:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2023\/10\/delete-sql-datascientest-1024x512-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"SQL DELETE: How do I use this query?\",\"datePublished\":\"2023-10-15T04:54:32+00:00\",\"dateModified\":\"2023-10-15T07:21:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\"},\"wordCount\":617,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Data Science\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\",\"url\":\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\",\"name\":\"SQL DELETE: How do I use this query?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2023-10-15T04:54:32+00:00\",\"dateModified\":\"2023-10-15T07:21:05+00:00\",\"description\":\"Learn how to effectively utilize SQL DELETE queries to remove specific data from your database. Explore the syntax, examples, and best practices for managing and maintaining your SQL databases.\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL DELETE: How do I use this query?","description":"Learn how to effectively utilize SQL DELETE queries to remove specific data from your database. Explore the syntax, examples, and best practices for managing and maintaining your SQL databases.","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\/en\/sql-delete-how-do-i-use-this-query","og_locale":"en_GB","og_type":"article","og_title":"SQL DELETE: How do I use this query?","og_description":"One of the must-have SQL queries is DELETE. And with good reason: this command lets you delete rows of data. But how do you use SQL DELETE? Let's find out","og_url":"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query","og_site_name":"DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2023-10-15T04:54:32+00:00","article_modified_time":"2023-10-15T07:21:05+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2023\/10\/delete-sql-datascientest-1024x512-1.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"SQL DELETE: How do I use this query?","datePublished":"2023-10-15T04:54:32+00:00","dateModified":"2023-10-15T07:21:05+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query"},"wordCount":617,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Data Science"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query","url":"https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query","name":"SQL DELETE: How do I use this query?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2023-10-15T04:54:32+00:00","dateModified":"2023-10-15T07:21:05+00:00","description":"Learn how to effectively utilize SQL DELETE queries to remove specific data from your database. Explore the syntax, examples, and best practices for managing and maintaining your SQL databases.","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/sql-delete-how-do-i-use-this-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/171940"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=171940"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/171940\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/171942"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=171940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=171940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=171940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}