{"id":171940,"date":"2026-01-28T03:53:46","date_gmt":"2026-01-28T02:53:46","guid":{"rendered":"https:\/\/liora.io\/en\/?p=171940"},"modified":"2026-08-08T12:44:25","modified_gmt":"2026-08-08T11:44:25","slug":"sql-delete-how-do-i-use-this-query","status":"publish","type":"post","link":"https:\/\/liora.io\/en\/sql-delete-how-do-i-use-this-query","title":{"rendered":"SQL DELETE: How do I use this query?"},"content":{"rendered":"\n

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<\/strong><\/p>\n\n\n

What is SQL DELETE?<\/h2>\n\n\n

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 SQL<\/a> DELETE query. This command allows you to delete all records you no longer need.<\/p>\n\n\n

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’s no going back. So if you want to recover data that has been inadvertently deleted, it’s best to have a backup.<\/p>\n\n\n

How do I use SQL DELETE to delete data?<\/h2>\n\n\n

The syntax for deleting data from a table is as follows:<\/p>\n\n\n

DELETE FROM `table`WHERE condition<\/p>\n\n\n

And to help you better understand the use of SQL DELETE, we’ve put together a number of concrete application cases. To this end, we use the “Client” table below:<\/p>\n\n\n

\n\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
ID<\/th>\nVorname<\/th>\nNachname<\/th>\nStadt<\/th>\nAlter<\/th>\nE-Mail<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nJustin<\/td>\nMartin<\/td>\nParis<\/td>\n29<\/td>\njustinemartin@gmail.com<\/td>\n<\/tr>\n
2<\/td>\nThomas <\/td>\nDurant<\/td>\nBordeaux<\/td>\n35<\/td>\ntomtom@sfr.fr<\/td>\n<\/tr>\n
3<\/td>\nMarie<\/td>\nLeroy<\/td>\nAngers<\/td>\n27<\/td>\nmarieleroy@laposte.net<\/td>\n<\/tr>\n
4<\/td>\nVanessa<\/td>\nSavary<\/td>\nMarseille<\/td>\n32<\/td>\nvanessa13@gmail.com<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n

Delete a single line<\/h3>\n\n\n

If you wish to delete a single line, simply register the following query:<\/p>\n\n\n

DELETE FROM `Client`WHERE `id` = 2<\/p>\n\n\n

In this example, we’ve deleted the row in the Customer table corresponding to ID 2. Here’s the result:<\/p>\n\n\n

\n\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n\n\n
ID<\/th>\nVorname<\/th>\nNachname<\/th>\nStadt<\/th>\nAlter<\/th>\nE-Mail<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nJustin<\/td>\nMartin<\/td>\nParis<\/td>\n29<\/td>\njustinemartin@gmail.com<\/td>\n<\/tr>\n
2<\/td>\nThomas <\/td>\nDurant<\/td>\nBordeaux<\/td>\n35<\/td>\ntomtom@sfr.fr<\/td>\n<\/tr>\n
3<\/td>\nMarie<\/td>\nLeroy<\/td>\nAngers<\/td>\n27<\/td>\nmarieleroy@laposte.net<\/td>\n<\/tr>\n
4<\/td>\nVanessa<\/td>\nSavary<\/td>\nMarseille<\/td>\n32<\/td>\nvanessa13@gmail.com<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n
Learn how to use SQL DELETE<\/a><\/div><\/div>\n\n\n

Delete several lines<\/h3>\n\n\n

You can easily delete several lines if they have common characteristics.<\/p>\n\n\n

For example, delete all customers over 30 years old.<\/p>\n\n\n

Here’s the query:<\/p>\n\n\n

DELETE FROM `Customer`WHERE ` ge` > ’30’<\/p>\n\n\n

And the result:<\/p>\n\n\n

\n\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
ID<\/th>\nVorname<\/th>\nNachname<\/th>\nStadt<\/th>\nAlter<\/th>\nE-Mail<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nJustin<\/td>\nMartin<\/td>\nParis<\/td>\n29<\/td>\njustinemartin@gmail.com<\/td>\n<\/tr>\n
3<\/td>\nMarie<\/td>\nLeroy<\/td>\nAngers<\/td>\n27<\/td>\nmarieleroy@laposte.net<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n

As a reminder, the WHERE clause allows you to specify the table rows you wish to delete.<\/p>\n\n\n

Delete all data<\/h3>\n\n\n

The syntax is as follows:<\/p>\n\n\n

DELETE FROM `tableau`<\/p>\n\n\n

Simply remove the WHERE conditional clause to remove all data from your table.<\/p>\n\n\n

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>\n\n\n

Delete rows between two datasets<\/h3>\n\n\n

The DELETE query can be used in conjunction with 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>\n\n\n

The syntax is as follows<\/p>\n\n\n

DELETE FROM Client WHERE id BETWEEN 1 AND 4.<\/p>\n\n\n

Here’s the result:<\/p>\n\n\n

\n\n\n\n\n\n\n\n<\/colgroup>\n\n\n\n\n\n
ID<\/th>\nPr\u00e9nom<\/th>\nNom<\/th>\nVille<\/th>\n\u00c2ge<\/th>\nEmail<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nJustin<\/td>\nMartin<\/td>\nParis<\/td>\n29<\/td>\njustinemartin@gmail.com<\/td>\n<\/tr>\n
4<\/td>\nVanessa<\/td>\nSavary<\/td>\nMarseille<\/td>\n32<\/td>\nvanessa13@gmail.com<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n

These are just a few simplified examples. In reality, the SQL DELETE command has many applications. If you’d like to learn more, join our training program.<\/p>\n\n\n

Join the Liora training course to learn more about SQL language<\/h2>\n\n\n

Mastering SQL is one of the fundamentals<\/a> for any data expert or developer. But between updates, deletions, additions… you need to know a multitude of SQL queries.That’s why we offer training courses at Liora. In addition to the SQL DELETE<\/a> command, you’ll learn all the queries that are essential for handling a relational database.<\/p>\n\n\n

Discover Liora’s training courses<\/a><\/div><\/div>\n\n","protected":false},"excerpt":{"rendered":"

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<\/strong><\/p>\n","protected":false},"author":78,"featured_media":171942,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"_acf_changed":false,"editor_notices":[],"footnotes":""},"categories":[2433],"class_list":["post-171940","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-ai"],"acf":[],"_links":{"self":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/171940","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/users\/78"}],"replies":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/comments?post=171940"}],"version-history":[{"count":4,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/171940\/revisions"}],"predecessor-version":[{"id":209939,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/posts\/171940\/revisions\/209939"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media\/171942"}],"wp:attachment":[{"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/media?parent=171940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/liora.io\/en\/wp-json\/wp\/v2\/categories?post=171940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}