Categories: python

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

Recent Posts

Find Intersection of Two Singly Linked Lists

You are given two singly linked lists that intersect at some node. Your task is…

3 months ago

Minimum Cost to Paint Houses with K Colors

A builder plans to construct N houses in a row, where each house can be…

3 months ago

Longest Absolute Path in File System Representation

Find the length of the longest absolute path to a file within the abstracted file…

3 months ago

Efficient Order Log Storage

You manage an e-commerce website and need to keep track of the last N order…

4 months ago

Select a Random Element from a Stream

You are given a stream of elements that is too large to fit into memory.…

4 months ago

Estimate π Using Monte Carlo Method

The formula for the area of a circle is given by πr². Use the Monte…

4 months ago