How To Update The Selected Row In MySQL Database Table Using Python
import mysql.connector
connection = mysql.connector.connect(
host='localhost',
user='root', password='',
port='3306',
database='test_py'
)
c = connection.cursor()
def updateData():
update_query = """UPDATE `users_2` SET
`firstname`=%s,`lastname`=%s,
`email`=%s,`age`=%s
WHERE `id` =%s """
vals = ("NewFName","NewLName","NewEmail@gmail.com",56,5)
c.execute(update_query,vals)
connection.commit()
updateData()
OUTPUT:
 |
| Python MySQL Update - Before Updating |
 |
| Python MySQL Update - After Updating |
Share this
Related Posts
C# Create Menu Using MySQL
How To Make A Menu Using MenuStrip And MySQL Database In C#
Using Python And Tkinter to Open, Read, and Save Text Files
How to Open, Read, and Save Text Files Using Python and Tkinter
VB.Net And MySQL DataBase - INSERT UPDATE DELETE SEARCH
VB.NET - How To Insert Update Search Delete Data From MySQL Using V
Python Average Value In a Tkinter Treeview ColumnHow to get the Average Value in a Tkinter Treeview Column Using Pythonimport tkinter as t
:)
:(
hihi
:-)
:D
=D
:-d
;(
;-(
@-)
:P
:o
:>)
(o)
:p
:-?
(p)
:-s
(m)
8-)
:-t
:-b
b-(
:-#
=p~
$-)
(y)
(f)
x-)
(k)
(h)
cheer