- mySQL database
- Basic Validation of input
- Add data
- Remove data
- Update data
- Clean interface
- Exception handling
- pymysql package from PIP
- Basic knowledge about Tkinter, SQL queries.
- MYSQL
Database/Schema : test
Table Name : students
- Below is table which indicates columns present in students table and its type/datatype
- Clone this project or Download Zip.
- Extract it and Open the Project in any IDE (Visual Studio Code or Pycharm)
- Open terminal (cmd in case of WIndows) and run following command
$ pip install pymysql
$ python main.py
- Done!
-
Database error! Check mydbhelper.py ?
--> Please make sure you have installed MYSQL with correct table name and with required columns. Open mydbhelper.py and change username and password with your credentials and type again. -
Other Questions.
-->Feel free to Connect with me on Telegram @vinayak_09.
Full Project demonstration Youtube :
Link - https://youtu.be/3Bj-bQZCzQY