Delete Query – MySQL

  • February 7, 2023
  • python
JOIN Clause

You must use the DELETE FROM statement to delete records from a MySQL table. To remove specific records, use the WHERE clause in conjunction with it.


Following is the syntax of the DELETE query in MYSQL −

DELETE FROM table_name [WHERE Clause]

Note: that the WHERE clause in the preceding syntax is used to specify the condition to pinpoint a specific record that you want to delete. If you do not specify a condition, all the table’s records will be deleted.

Example: Below is a program to delete a query from the table in the database.

import mysql.connector

# Connecting to the Database
mydb = mysql.connector.connect(
host ='localhost',
database ='School',
user ='root',

cursor = db.cursor()
## defining the Query
query = "DELETE FROM students WHERE ROLL = 21"

## executing the query

## final step to tell the database that we have changed the table data

If the above code runs without an error then it means that the row with roll = 21 is deleted successfully.

Note: also read about Update Query-MySQL

Follow Me

Please follow me to read my latest post on programming and technology if you like my post.

Leave a Reply

Your email address will not be published. Required fields are marked *