python-mysqlHow can I use Python MySQL libraries to develop software?
Python can be used to develop software that interacts with a MySQL database. To do this, you need to use one of the Python MySQL libraries. Examples of such libraries are mysql-connector
, MySQLdb
, and PyMySQL
.
Below is an example using the mysql-connector
library:
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="user",
passwd="passwd"
)
mycursor = mydb.cursor()
mycursor.execute("SHOW DATABASES")
for x in mycursor:
print(x)
Output example
('information_schema',)
('mydatabase',)
('mysql',)
('performance_schema',)
('sys',)
The code above:
- Imports the
mysql.connector
library - Connects to the database
- Creates a cursor
- Executes a SQL query
- Iterates over the result set and prints each row
Helpful links
More of Python Mysql
- How can I use the MySQL Connector in Python?
- How can I use Python and MySQL to generate a PDF?
- How can I connect Python to a MySQL database?
- How do I use Python to query MySQL with multiple conditions?
- How can I use Yum to install the MySQLdb Python module?
- How do I use Python to connect to a MySQL database using XAMPP?
- How do I use Python to authenticate MySQL on Windows?
- How do I use a cursor to interact with a MySQL database in Python?
- How can I use a while loop in Python to interact with a MySQL database?
- How can I check the version of MySQL I'm using with Python?
See more codes...