Today, we will learn MySQL CRUD operation using python programming with Tkinter GUI-based application. We will see how to establish a MySQL connection and perform Insert, Update, Delete, and Select operations with the GUI application.
Before you create this application, you need to download MySql Server.
1. How to install MySQL: https://youtu.be/a8DCItIbSas
2. How to install MySQL Workbench: https://www.youtube.com/watch?v=81YOHhIRKK0
Once MySQL is downloaded and installed, make sure you install MySQL connector and Tkinter libraries to use in python.
1. pip install mysql-connector-python
2. sudo apt-get install python3-tk
Timestamp:
0:00 - Intro
2:50 - Import packages
3:30 - GUI Design
8:38 - Insert function
15:00 - Delete function
18:35 - Update function
25:13 - Select function
For full source code, Visit : https://codewithap.com/mysql-crud-operations-python/
