LaravelCode

Search

Python MySQL Database Connection using MySQL Connector module

Python
1848 views 2 years ago
post-title

Python is fast when working and analysing large size of database. To work with MySQL in Python, first you need to install MySQL Driver for Python. In this article we will use mysql-connector driver to work with Python3. pip is the package installer for Python. You can use pip to install packages from the Python Package Index. We recommend you use pip to install Python packages.

To install MySQL driver, run the below command in Terminal.

python3 -m pip install mysql-connector-python

Now in python file, first import mysql connector.

import mysql.connector

Now create a connection to the database.

mysql_database = mysql.connector.connect(
    host = 'localhost',
    user = 'root',
    password = 'root',
    database = 'database',
    autocommit = True
)

mysql_cursor = mysql_database.cursor()

That's it. Your MySQL database is connected with Python. Now you can run MySQL query in Python.

query = "SELECT * FROM users WHERE country = 'US'"
mysql_cursor.execute(query)
users = mysql_cursor.fetchall()

for x in users:
    print(x)

Same way you can use all MySQL query in Python. If the query changes anything in the table you need to commit() the query to make changes in database or you can add autocommit = True in your connection code.

query = "INSERT INTO users (first_name, last_name, address) VALUES ('John', 'Doe', 'Freemount Street')"
mysql_cursor.execute(query)
mysql_database.commit()

Here is index.py file with full code:

#!/usr/bin/python
import mysql.connector

# connect with database
mysql_database = mysql.connector.connect(
    host = 'localhost',
    user = 'root',
    password = 'root',
    database = 'neo',
    autocommit = True
)

# run query
query = "INSERT INTO users (first_name, last_name, address) VALUES ('John', 'Doe', 'Freemount Street')"
mysql_cursor.execute(query)
mysql_database.commit()

# close connection with database
mysql_database.close()

I hope this will help you in your day-to-day work. In next article, we will see on how to connect MongoDB with Python.

Random Articles
  • How to Install Tailwind in React.js
    Introduction Are you a React.js developer looking to enhance your web development projects with the power and flexibility of Tailwind CSS? Look no further! In this comprehensive guide, we will walk...
  • Run Python Script in Laravel
    When running huge Laravel project with lacs or records, for processing them you might want to use node.js or Python language. Or you want to use OCR, then you need Python which can process the task ea...
  • Check if Array is Empty or null in Javascript
    When working in Javascript, many times you need to check if array is empty or undefined. This needs to check when you want to loop the array, so it doesn't return error. There are lot of ways t...
  • How to get selected file name from input type file using jQuery
    Use the jQuery change() method You can use the jQuery change() method to get the file name selected by the HTML form control <input type="file">. Let's check out an example to u...
  • Laravel Eloquent Has One of Many Relationship Tutorial with Example
    Laravel provides eloquent relationship which provides powerful query builders. In Laravel, eloquent relationships are defined in model classes. Laravel eloquent provides easy ways to create common rel...
Advertise