python-mysqlHow can I use Python to retrieve data from MySQL?
You can use Python to retrieve data from MySQL by using the Python MySQL connector library. This library provides an interface for connecting to a MySQL database server and executing SQL statements.
Example code
import mysql.connector
# Connect to the database
mydb = mysql.connector.connect(
host="localhost",
user="user",
passwd="passwd",
database="mydatabase"
)
mycursor = mydb.cursor()
# Execute a query
mycursor.execute("SELECT * FROM customers")
# Fetch all the results
myresult = mycursor.fetchall()
# Print the results
for x in myresult:
print(x)
Output example
(1, 'John', 'Lowstreet 4')
(2, 'Peter', 'Lowstreet 5')
(3, 'Amy', 'Lowstreet 6')
The code consists of the following parts:
- Importing the MySQL Connector library -
import mysql.connector - Connecting to the database -
mydb = mysql.connector.connect(host="localhost", user="user", passwd="passwd", database="mydatabase") - Creating a cursor object -
mycursor = mydb.cursor() - Executing a query -
mycursor.execute("SELECT * FROM customers") - Fetching the results -
myresult = mycursor.fetchall() - Printing the results -
for x in myresult: print(x)
Helpful links
More of Python Mysql
- How can I connect Python to a MySQL database?
- How do I connect Python with MySQL using XAMPP?
- How do I use Python to query MySQL with multiple conditions?
- How do I use Python to perform an INSERT ON DUPLICATE KEY UPDATE query in MySQL?
- How can I install the MySQL-Python (Python 2.x) module?
- How do I insert JSON data into a MySQL database using Python?
- How can I use Yum to install the MySQLdb Python module?
- How can I create a web application using Python and MySQL?
- How do Python MySQL and SQLite compare in terms of performance and scalability?
- How can I handle null values in a MySQL database using Python?
See more codes...