This Python script creates and manages a music store database. It allows users to add, search, modify, and delete customer and music records.
- Creates a database named "python" with two tables: "customer_details" and "music".
- Manages customer details including code, name, phone number, issue date, and return date.
- Manages music details including code, name, artist, genre, release year, price, and quantity.
- Provides functionalities for adding, searching, modifying, and deleting customer and music records.
- Python 3.x
- mysql.connector library (you can install it using pip install mysql-connector-python)
- Make sure you have Python 3 and mysql.connector installed.
- Save the script as music_store.py.
- Run the script from your terminal: python music_store.py
- The script will prompt you to choose an action from a menu.
- Follow the on-screen instructions to add, search, modify, or delete customer and music records.