Lesson - 57 : Python Advanced - Python Database Access : MySQL Delete Data

Описание: **************************************************
Python Core PlayList :    • Lesson - 01 : Python3 - What is python  
Python Advanced PlayList :    • Lesson - 46 : Python Advanced - Python OOP...  
**************************************************

Python Database Access : MySQL Update Data:

To update data in a MySQL table in Python, you follow the steps below:
Connect to the database by creating a new MySQLConnection object.
Create a new MySQLCursor object from the MySQLConnection object and call the execute()method of the MySQLCursor object. To accept the changes, you call the commit() method of the MySQLConnection object after calling the execute() method. Otherwise, no changes will be made to the database.
Close the cursor and database connection.

Example :
db_config = read_db_config()
prepare query and data
query = """ UPDATE books SET title = %s WHERE id = %s """
data = (title, book_id)
conn = MySQLConnection(**db_config)
update book title
cursor = conn.cursor()
cursor.execute(query, data)
accept the changes
conn.commit()

Sample Projects : https://github.com/SadaLearningHub1/P...