Skip to content

README.md

Latest commit

 

History

History
37 lines (26 loc) · 1 KB

README.md

File metadata and controls

37 lines (26 loc) · 1 KB

Library Management System

Develop a library management system that tracks books, borrowers, due dates and other essential details. Users can check out and return books, and the system should maintain records in a MySQL database.

Prerequisites

Before you get started, make sure you have the following installed:

Setup python,MySQL and their respective PATH environment variables.

Getting Started

  • Go to command prompt and type:
pip install mysql-connector-python
  • Create a database and the necessary tables.

Usage

-In the Python file begin with the following code to connect it to the MySQL database:

import mysql.connector

mydb = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)
  • Execute the necessary sql queries using Python to input and output data.