MySQL官方文档:https://dev.mysql.com/doc/
MySQL.Connector / Python 文档:https://dev.mysql.com/doc/connector-python/en/
最新版本:Connector/Python 8.0.16
PyCharm的截图,可以根据该名称搜索三方库。
import mysql.connector
cnx = mysql.connector.connect(user = 'root', password = '12345678',
host = '127.0.0.1',database = 'py_mysql' )
cursor = cnx.cursor()
SQL = "INSERT INTO message01 (ArbID, data) VALUES " + str_values
cursor.execute(SQL)
cnx.commit()
cnx.close()
这是一个最简单的例子,
更详细的使用可参考官方文档:https://dev.mysql.com/doc/connector-python/en/connector-python-examples.html