Python连接Mysql数据库

#导入第三方库
import pymysql
#连接数据库
conn=pymysql.Connect(
    host="127.0.0.1",
    port=3306,
    db="test",
    user="root",
    password="mysql",
    charset="utf8"
)
#建立游标
cur=conn.cursor()
insert_sub="insert into user values(3,'yhj') "
#执行SQL语句
result=cur.execute(insert_sub)
print(result)
#不能忘记commit
conn.commit()
conn.close()