{"id":12408,"date":"2020-12-14T14:05:22","date_gmt":"2020-12-14T22:05:22","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=12408"},"modified":"2023-12-01T04:05:55","modified_gmt":"2023-12-01T12:05:55","slug":"sql-delete-row","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-delete-row\/","title":{"rendered":"SQL Delete Row: A Guide"},"content":{"rendered":"\n

The SQL DELETE statement deletes a row from a database table. You can use the WHERE statement to specify which records should be deleted. If you do not specify a where statement, every row in the table will be deleted.<\/em><\/p>\n\n\n\n

Deleting rows is a common operation in SQL<\/em>. For example, a user may decide to delete their account on your website. This will require you to remove their data from your user database.<\/p>\n\n\n\n

You can use the SQL DELETE<\/em> statement to remove any rows from your table. In this tutorial, we are going to discuss how you can perform an SQL delete row<\/em> command on your database.<\/p>\n\n\n\n

SQL Records Refresher<\/h2>\n\n\n\n

Databases are made up of a series of tables, each of which stores their own records.<\/p>\n\n\n\n

For example, our company database may include tables on employees, suppliers, departments, payroll, and more. Each of those tables would include their own records, which are individual entries in a table. A payroll table may include a list of payments made to employees.<\/p>\n\n\n\n

In order to add a new record to a table, we use an SQL<\/a> INSERT<\/em> statement. This allows us to add a record containing specific values to a column of our choosing.<\/p>\n\n\n\n

Here\u2019s an example of an SQL INSERT<\/em> command in action:<\/p>\n\n\n\n

INSERT INTO company_departments (name, department_id) VALUES ('Payroll', 5);<\/pre><\/div>\n\n\n\n
But what if we want to remove a row from our table? We can use the DELETE row statement to accomplish this goal.<\/p>\n\n\n\n
SQL Delete Row from Table<\/h2>\n\n\n\n
The SQL DELETE<\/em> statement removes a row or multiple rows from a table. The statement takes in two parameters. First, you should specify table name that the DELETE<\/em> statement should focus on. Optionally, specify any conditions that must be met before a record is deleted.<\/p>\n\n\n\n
Here is the syntax for a DELETE<\/em> statement:<\/p>\n\n\n\n
DELETE FROM table_name WHERE conditions_are_met;<\/pre><\/div>\n\n\n\n
A delete statement does not have any “undo” command. Once a record has been removed from a database, it cannot be recovered.<\/p>\n\n\n\n
A WHERE statement lets you specify which records should be deleted. This uses the same syntax as an SQL WHERE<\/em><\/a> statement with any other command, like SQL INSERT<\/em> or UPDATE<\/em>.<\/p>\n\n\n\n
The DELETE<\/em> statement does not delete a table. It will delete the records within that table.<\/p>\n\n\n\n
Let’s take a look at an example of the SQL DELETE<\/em> statement.<\/p>\n\n\n\n
Delete Row SQL Example<\/h3>\n\n\n\n
If we want to delete only records that match a certain set of conditions, we can do so by specifying a WHERE<\/em> clause. Let\u2019s say that we have decided that the Marketing<\/em> department should be merged into sales.<\/p>\n\n\n\n
Our table currently contains the following records:<\/p>\n\n\n\n
name<\/td>title<\/td>department_id<\/td><\/tr>
John
<\/td>		Marketing
<\/td>		2
<\/td><\/tr>
Rebecca<\/td>Sales<\/td>3<\/td><\/tr><\/tbody><\/table>\n\n\n\n
We\u2019ll use a DELETE query to delete the Marketing<\/em> department from our list:<\/p>\n\n\n\n
DELETE FROM company_departments WHERE title = 'Marketing';<\/pre><\/div>\n\n\n\n
We can check if our record has been deleted using an SQL SELECT<\/a> statement. Our result set is:<\/p>\n\n\n\n
name<\/td>title<\/td>department_id<\/td><\/tr>
Rebecca<\/td>Sales<\/td>3<\/td><\/tr><\/tbody><\/table>\n\n\n\n
Rebecca’s employee record was not affected by our DELETE operation because we only deleted people whose title was equal to “Marketing”. But, John’s records is gone. This is because John worked for the marketing department.<\/p>\n\n\n\n
In this case, we have deleted a single record. If there were more employees in the marketing department, their records would have been removed too.<\/p>\n\n\n\n
Delete All Rows SQL Example<\/h3>\n\n\n\n
So, let\u2019s say that we want to delete all the records in our company_departments<\/em> table because we are undergoing a corporate reorganization. We could use this command to delete those records:<\/p>\n\n\n\n
DELETE FROM company_departments;<\/pre><\/div>\n\n\n\n
This query removes all rows in our table company_departments<\/em>. This is because we have not specified any conditions that must be met before a record is deleted. If you omit the where clause from any DELETE<\/em> command, it will delete all rows within the table.<\/p>\n\n\n\n
If we query our company_departments<\/em> table to look for any employee with the title Marketing<\/em>, we can see that there are no records:<\/p>\n\n\n\n
name<\/td>title<\/td>department_id<\/td><\/tr>

<\/td>
<\/td>
<\/td><\/tr><\/tbody><\/table>\n\n\n\n
(0 rows)<\/p>\n\n\n\n