Python-操作MySQL

1. 下载pymysql

pip install pymysql

2. 导入库

import pymysql

3. 方法封装

(1) 连接数据库

def getConnect(HOST, USER, DB_PASSWD, DB_NAME):
    try:
        connect = pymysql.connect(host=HOST, user=USER, password=DB_PASSWD, database=DB_NAME)
        print('连接成功！')
        return connect
    except pymysql.Error as e:
        print("连接失败：" + str(e))

(2) 创建一个表

def createTable(cur, sql1, sql2):
    try:
        cur.execute(sql1
        cur.execute(sql2) 
        print('表创建成功！')
    except pymysql.Error as e:
        print("表创建失败：" + str(e))

(3) 插入数据

def insertData(cur, connect, sql, value):
    try:
        cur.execute(sql, value)
        connect.commit()
        print('数据插入成功！')
    except pymysql.Error as e:
        print("数据插入失败：" + str(e))
        connect.rollback()

(4) 修改数据

def updateData(cur, connect, sql