How To Delete Record From MySQL Database Using Python
import mysql.connector
connection = mysql.connector.connect(
host='localhost',
user='root', password='',
port='3306',
database='test_py'
)
c = connection.cursor()
def deleteData(user_id):
delete_query = "DELETE FROM `users_2` WHERE `id` = " + user_id
c.execute(delete_query)
connection.commit()
deleteData("8")
OUTPUT:
 |
| Python MySQL Delete Record - Before |
 |
| Python MySQL Delete Record - After |
Share this
Related Posts
PHP Inventory Management System Source CodeInventory Management System In PHP With Source Codein this php project demo, yo
Python - Create Image Slider In TkinterHow To Make a Python Image Slider Using Tkinter
In this Python Tutorial
Python & MySQL - How to Populate TreeView from MySQL Database in Python Tkinter
How to Load Data from MySQL Database into Tkinter TreeView using Python
Python Analog Clock Using Tkinter
How to Create Analog Clock In Python Tkinter
In this Python tu
:)
:(
hihi
:-)
:D
=D
:-d
;(
;-(
@-)
:P
:o
:>)
(o)
:p
:-?
(p)
:-s
(m)
8-)
:-t
:-b
b-(
:-#
=p~
$-)
(y)
(f)
x-)
(k)
(h)
cheer