MySQL Delete Query

MySQL Delete Query:

There are times when some data is not needed any longer and may even pose problems by remaining in the database. To discard unwanted data from a database, we will use the DELETE Query, which allows you to delete one or more records in a table: The Syntax of MySQL Delete Query is:

DELETE FROM table_name [WHERE Clause]

The DELETE Query deletes the rows from table_name and returns the number of rows deleted. The WHERE clause is used to specify the conditions that identify which rows to be deleted. If the DELETE Query contains without a WHERE clause, all rows will be deleted.

Sample Table:

MySQL Sample Table for Delete Query

Example 1: Delete 3rd StudentId from the table.

MySQL Delete Query Example

Example 2: Delete the 7th, 8th, and 9th StudentId from the table.

MySQL Delete Query Example to delete multiple rows

Natural Language Processing (NLP)- Complete Introduction
MySQL Limit and Offset Clause
MySQL Order By and Distinct Clause
MySQL Between and Not Between Operators
MySQL Select Query with Where Clause
MySQL– Wikipedia

Comments (No)

Leave a Reply