World's Best AI Learning Platform with profoundly Demanding Certification Programs
Designed by IITians, only for AI Learners.
Internship Partner
In Association with
In collaboration with
SIGN IN to your Account
New to InsideAIML? Create an account
Employer? Create an account
World's Best AI Learning Platform with profoundly Demanding Certification Programs
Designed by IITians, only for AI Learners.
Internship Partner
In Association with
In collaboration with
Forgot Your Password?
Enter your email below and we will send a message to reset your password
World's Best AI Learning Platform with profoundly Demanding Certification Programs
Designed by IITians, only for AI Learners.
Internship Partner
In Association with
In collaboration with
Sign Up and Start Learning!
By providing your contact details, you agree to our Terms of Use & Privacy Policy.
Already have an account? Sign In
World's Best AI Learning Platform with profoundly Demanding Certification Programs
Designed by IITians, only for AI Learners.
Internship Partner
In Association with
In collaboration with
Sign Up and Start Learning!
By providing your contact details, you agree to our Terms of Use & Privacy Policy.
Already have an account? Sign In
Download our e-book of Introduction To Python
Related Blog
Matplotlib - Object-oriented InterfaceMatplotlib - MultiplotsCNTK - Creating First Neural NetworkMatplotlib - Working with ImagesMicrosoft Cognitive Toolkit (CNTK) - CPU and GPUPython Forensics - Memory and ForensicsPython Blockchain - Scope and ConclusionDiscuss Microsoft Cognitive ToolkitMatplotlib - Twin AxesMatplotlib - Subplot2grid() Function View More
Top Discussion
Exception Type: JSONDecodeError at /update/ Exception Value: Expecting value: line 1 column 1 (char 0) How can I write Python code to change a date string from "mm/dd/yy hh: mm" format to "YYYY-MM-DD HH: mm" format? How to choosing the right estimator for the machine learning problem? How to Write Python ZIP File? How to extracting text from PDF file using python How can a web interface execute a .py file from a PHP file? What methods can we use to differentiate between correlated and uncorrelated variables in a regression analysis? How to leave/exit/deactivate a Python virtualenvironment Join Discussion
Top Courses
Master's In Artificial Intelligence Program in Collaboration With IBM
4.5 (1,292 Ratings)
589 Learners
Webinars
Why You Should Learn Data Science in 2023
Sep 30th (7:00 PM) 1117 Registered
Discuss Python MySQL
Vijay Parekh
2 years ago
Table of Contents
- Introduction
- Installing MySQL
- Steps
- Connecting to MySQL Database
- Creating Databases
- Creating a cursor object and Execute the query
Introduction
Python is a general-purpose interpreted, interactive, object-oriented, and high-level programming language. It was created by Guido van Rossum during 1985-1990. Like Perl, Python source code is also available under the GNU General Public License (GPL). This tutorial gives enough understanding on Python programming language. This tutorial explains how to communicate with MySQL database in detail, along with examples.
Installing MySQL
Download and install MySQL from the MySQL official website. You need to install the MySQL server to follow this tutorial. Then you need to install mysql.connector for Python. We need mysql.connector to connect Python Script to the MySQL database. mysql.connector from here and install it on your computer.
Steps
There are the following steps to connect a python application to our database.
- Import mysql.connector module
- Create the connection object.
- Create the cursor object
- Execute the query
Connecting to MySQL Database
The connect () method of the mysql.connector module is used to establish a connection between the MySQL database and the Python application. Pass the database details such as hostname, username and password for the database in the method call. The method returns the connection object. .
import mysql.connector as mysql
test= mysql.connect(
host="localhost",
user="username",
password="password"
)
print(test)Output
>python demo_mysql_connection.py
<mysql.connector.connection.MySQLConnection object ar 0x016645F0>Creating Databases
To create a database in MySQL, we use CREATE DATABASE database_name statement.
import mysql.connector as mysql
test= mysql.connect(
host="localhost",
user="username",
password="password"
)
mycursor = test.cursor()
mycursor.execute("CREATE DATABASE mydatabase")Creating a cursor object and Execute the query
The cursor object can be defined as an abstraction specified in Python DBAPI 2. It makes it easier for us to have several separate working environments through the same connection to the database. We can create the cursor object by using the 'cursor' function of the connection object. The cursor object is an important aspect when executing database queries.
import mysql.connector as mysql
test= mysql.connect(
host="localhost",
user="yourusername",
password="yourpassword"
)
mycursor = test.cursor()
mycursor.execute("SHOW DATABASES")
for x in mycursor:
print(x)Output
('information_scheme',)
('mydatabase',)
('performance_schema',)
('sys',)Enjoyed reading this blog? Then why not share it with others. Help us make this AI community stronger.
To learn more about such concepts related to Artificial Intelligence, visit our insideAIML blog page.
You can also ask direct queries related to Artificial Intelligence, Deep Learning, Data Science and Machine Learning on our live insideAIML discussion forum.
Keep Learning. Keep Growing.