python 3数据库连接

python 3数据库连接

1 需要pymysql

pip install PyMysql

2 连接，写入数据

db = pymysql.connections.Connection(
        host='sever name',
        port=3306,
        user='root',
        password='***',
        database='table名称',
        charset='utf8mb4',
    )
   
#创建游标
cursor = db.cursor()
#利用占位符，写入
sqlLanguage = 'INSERT INTO person (student_name,id,class_name) VALUES("%s","%s","%s")' %(student_name,id,class_name)
cursor.execute(sqlLanguage)
db.commit()

db.close()