Database and Tables in Use

Introduction

This is a boutique management system made using MySQL connectivity with Python. It uses a MySQL database to store data in the form of tables and to maintain a proper record of all details. Different SQL queries that include DDL, DQL, DML, and DCL commands are used in this project which is useful to perform CRUD (Create, Read, Update, Delete) operations using MySQL. This management system provides a common platform for customers, employees, as well employers to use the services. The various functionalities provided in this system are:...

Prerequisites

MySQL should be installed on our system. Refer to this link to Download the MySQL installer. Once MySQL Server is installed properly, we can create databases and tables using MySQL commands in MySQL Command-Line-Client. MySQL Command Line Client is installed together with the MySQL Server, so you don’t need to download and install the MySQL client separately. To check whether you have the client program on your machine, go to search, and type “MySQL”. To access MySQL Server from the command-line client, open the program and enter the password after that, you will be able to use the client....

Checking the table structure and data stored in the table

USE sboutique; SHOW TABLES;...

Getting Started

We need to make a connection between the MySQL database and Python so that the tables can be accessed using python IDE. For making a connection we need to install mysql-connector which can be done by writing the following command in the command prompt on Windows....

Database and Tables in Use :

...

Functions in the program

The name of the MySQL Database used is “sboutique” and the following tables are used :...

Main Program

1. Check() Function...

Records in the Tables after executing the program:

...