Question

python怎么链接mysql

Answer 1

使用PyMySQL操作mysql数据库

适用环境

python版本 >=2.6或3.3

mysql版本>=4.1

import pymysql.cursors
 
# Connect to the database
connection = pymysql.connect(host='127.0.0.1',
                             port=3306,
                             user='root',
                             password='zhyea.com',
                             db='employees',
                             charset='utf8mb4',
                             cursorclass=pymysql.cursors.DictCursor)