This is a beginner-friendly Python project that connects to a MySQL database to perform basic CRUD operations (Create, Read, Update, Delete).
It serves as a simple command-line interface for managing data entries like students, employees, etc.
- Add new records to the database
- View all existing records
- Update specific entries
- Delete entries from the database
- Clean terminal-based user interface
- Python 3
- MySQL
mysql.connector(Python library)
- Make sure MySQL is installed and running.
- Create a database and table (refer to
setup.sqlif provided). - Update your database connection settings in the script:
connection = mysql.connector.connect( host="localhost", user="your_mysql_username", password="your_mysql_password", database="your_database_name" )
- Install the required package: pip install mysql-connector-python