Inventory Management System

A console-based Inventory Management System built using Python and MySQL to manage product records efficiently

This project was built to practice backend programming and relational database concepts.

Features

• Add new inventory items
• Display all records
• Update existing item details
• Search inventory by ID
• Delete inventory records
• Menu-driven console interface
• MySQL database with primary key constraints

Tech Stack

• Python
• MySQL

Purpose

This project was created to strengthen the understanding of:

1. Python–MySQL integration
2. CRUD operations
3. SQL queries
4. Database design

Languages

• Python
• SQL (MySQL)

How to Run

1. Ensure MySQL is installed and running
2. Create the database and table using the .sql file.
3. Install dependency:

   pip install mysql-connector-python

4. Download the .py file & replace (your MySQL server password) with Your_Password.
5. Run the Python Script

Author

Ojas Deshpande [[email protected]]