This recipe will use the code from the previous recipe, explain it in more detail, and then extend the code to update our data.
In order to update data we have previously inserted into our MySQL database tables, we use the SQL UPDATE command.
This recipe builds on the previous recipe, so read and study the previous recipe in order to follow the coding in this recipe where we modify existing data.
First, we will display the data to be modified by running the following Python to MySQL command:
import mysql.connector as mysql
import GuiDBConfig as guiConf
class MySQL():
# class variable
GUIDB = 'GuiDB'
#------------------------------------------------------
def showData(self):
# connect to MySQL
conn, cursor = self.connect()
self.useGuiDB(cursor)
# execute command
cursor.execute("SELECT * FROM books")
print(cursor.fetchall())
cursor.execute...