Question

How to run SQL update query in MySQL database to update existing record in Python

Answer 1

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
    
import mysql.connector
    
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
   
db_cursor = db.cursor()

sql = "UPDATE workers SET profession='C-Sharp Programmer' WHERE first_name='Ben'"

db_cursor.execute(sql)

db.commit()

print(db_cursor.rowcount, "record affected")

db.close()

 
'''
run:

1 record affected

'''

 

70+ SQL courses for beginners and professionals

Answer 2

# c:\Users\user_nm\AppData\Local\Programs\Python\Python35-32\Scripts\pip install mysql-connector
    
import mysql.connector
    
db = mysql.connector.connect(
    host="localhost",
    user="root",
    passwd="",
    database="python_database"
)
   
db_cursor = db.cursor()

sql = "UPDATE workers SET profession=%s WHERE first_name=%s"

data = ("C-Sharp Programmer", "Ben")

db_cursor.execute(sql, data)

db.commit()

print(db_cursor.rowcount, "record affected")

db.close()

 
'''
run:

1 record affected

'''

 

70+ SQL courses for beginners and professionals