MySQL Python CRUD Operations This is a simple Python application that demonstrates how to connect to a MySQL database and perform basic CRUD (Create, Read, Update, Delete) operations.
Features Connects to a MySQL database using Python.
Performs basic CRUD operations on a database table:
Create new records.
Read existing records.
Update records.
Delete records.
Setup
- Install Dependencies Clone the repository and install the required libraries:
bash Copy Edit git clone https://github.com/yourusername/mysql-python-crud.git cd mysql-python-crud pip install mysql-connector-python 2. Set Up MySQL Make sure MySQL is installed and running on your machine. Create a new database and user, then update the connection details in the connection.py file.
- Run the Application Once your database is set up, run the Python script to test the connection and perform CRUD operations:
bash Copy Edit python connection.py