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:
Example 1: Delete 3rd StudentId from the table.
Example 2: Delete the 7th, 8th, and 9th StudentId from the table.
Comments (No)