Python连接mysql

python连接mysql

连接前的准备

需要安装MySql驱动：

pip install pymysql

连接mysql执行数据库语句

import pymysql

# 创建数据库连接
connection = pymysql.connect(
host='localhost',
user='username',
password='password',
database='mydatabase',
charset='utf8'
)

# 创建游标对象
cursor = connection.cursor()

#执行语句
cursor.execute("select * from user")
results = cursor.fetchall()
for row in results:
    print(row)