Skip to content

School Library Management Project #104

Description

@shiv325

Python MySQL Project : School Library Management

  1. Python
  2. MySQL Connector Python
  3. Tables Created

Python

  • All Operations through MySQL Commands
  • Handles DataBases, Tables and the Data Stored in Tables

MySQL Connector Python

  • Connects Python with MySQL DataBase through a Connection Object
  • Cursor is associated to Connection Object
  • This Cursor helps execute SQL Commands in Python
  • Cursor stores the corresponding Output Data which can be obtained from it
  • Cursor can also Create Tables and DataBases

To install this connector, use the following command in your terminal :
pip install mysql-connector-python

Tables Formed

  1. school_students
  2. library_books
  3. issued_books

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions