Database-Application-Menu-Driven-Program

Python MySQL Database Connector: Manage User Data Efficiently

Description:

This Python script facilitates seamless interaction with a MySQL database, allowing users to perform essential CRUD operations (Create, Read, Update, Delete) on user data. With a simple command-line interface, users can effortlessly insert new records, retrieve existing data, update information, and delete entries as needed. The script utilizes the mysql.connector library for establishing connections and executing queries efficiently.

Features:

• User-friendly Interface: The script offers a straightforward command-line interface, making it easy for users to interact with the database.
• Efficient Data Management: Perform CRUD operations efficiently - insert, retrieve, update, and delete user records with ease.
• Robust Connectivity: Utilizes mysql.connector to establish secure connections with MySQL databases.
• Data Integrity: Ensures data integrity by utilizing SQL queries to enforce primary keys and maintain consistency within the database.
• Error Handling: Incorporates error handling mechanisms to provide informative messages in case of incorrect input or database-related issues.

How to Use:

1. Installation:

   • Ensure you have Python installed on your system.
   • Install the mysql.connector library using pip:

     pip install mysql-connector-python
     

2. Configuration:

   • Modify the database connection details (host, user, password, database) in the script according to your MySQL setup.

3. Execution:

   • Run the script in your preferred Python environment.
   • Follow the prompts to perform various operations:
     • Insert new user data.
     • Display all existing records.
     • Delete specific user data.
     • Update existing user information.
     • Exit the program.

Requirements:

• Python 3.x
• mysql.connector library

Author:

Sanju Dhritlahre

License:

This project is licensed under the MIT License.

Contributions:

Contributions are welcome! Feel free to submit issues, feature requests, or pull requests to enhance the functionality of this script.

Disclaimer:

This script is provided as-is, without any warranties or guarantees. Use it at your own discretion.

Acknowledgments:

Special thanks to the developers of mysql.connector for providing a robust library for MySQL connectivity in Python.