Delete Query – MySQL

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.

Syntax:

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
cursor.execute(query)

## final step to tell the database that we have changed the table data
db.commit()

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.

https://www.instagram.com/coderz.py/

https://www.facebook.com/coderz.py