一、安装mysql-connector 驱动
命令是:pip install mysql-connector
直到提示安装成功即可。
import mysql.connector
如果没有报错,就表示安装成功!
二、创建MySQL数据库连接
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "123456",
database = "test"
)
三、向表中插入一条数据
from mysql.connector import connect
#import mysql.connector
#创建mysql的连接
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "123456",
database = "test"
)
#建立一个数据库的操作集
mycursor = mydb.cursor()
#增加数据
sql = "INSERT INTO temp(id,NAME,age) VALUES(%s,%s,%s);"
val = (6,"wsg5",38)
#运行SQL
mycursor.execute(sql,val)
mydb.commit