Page 45 - Phyton_GUIprogrammingwithTkinter

P a ge | 36

iii. Open IDLE Shell and it will show as the following when data is successfully
updated.

iv. Open your MySQL Workbench and see the changes. It will show as the
following.

7. DELETE Operation

i. Delete data the same as updating data. Use the query DELETE to delete and
WHERE to determine the data to be deleted.
ii. Create a new file named delete.py, then fill it with the following code:

iii. In the code above, data with customer_id = 1 will be deleted.