python操作MySQL(自家用)

1.先升级pip
cmd输入：python -m pip install --upgrade pip
2.安装python控制下的pymysql
cmd输入：pip install PyMySQL
3.使用 pip 命令来安装 mysql-connector驱动
cmd输入：python -m pip install mysql-connector
4.链接数据库
from selenium import webdriver
import time
import pymysql
import mysql.connector

conn = pymysql.connect(host='数据库地址',user='用户名',password='密码',database='数据库名',charset='utf8')
cursor = conn.cursor()
sql = "insert into cruisor (brand,model) values ('Toyota','prado')"
cursor.execute(sql)
cursor.close()