Extract Data from Database using MySQL-Connector and XAMPP in Python
A connector is employed when we have to use MySQL with other programming languages. The work of mysql-connector is to provide access to MySQL Driver to the required language. Thus, it generates a connection between the programming language and the MySQL Server.
- XAMPP: Database / Server to store and display data.
- MySQL-Connector module: For connecting the database with the python file. Use the below command to install this module.
pip install mysql-connector
- Wheel module: A command line tool for working with wheel files. Use the below command to install this module.
pip install wheel
Procedure to create a table in the database:
- Start your XAMPP web server.
- Type http://localhost/phpmyadmin/ in your browser.
- Go to Database create database with name and click on Create.
- Create a table with in GEEK database and click on Go.
- Define column names and click on save.
- Your table is created.
- Insert data in your database by clicking on SQL tab then select INSERT.
- The data in your table is:
- Now you can perform operation IE display data in your web page using python
Procedure for writing Python program:
- Import mysql connector module in your Python code.
- Create connection object.
Here, you will need to pass server name, username, password, and database name)
- Create a cursor object.
- Perform queries on database.
query=DDL/DML etc cur_obj=execute(query)
- Close cursor object.
- Close connection object.
Below is the complete Python program based on the above approach:
Note: XAMPP Apache and MySQL should be kept on during the whole process.
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course. And to begin with your Machine Learning Journey, join the Machine Learning – Basic Level Course