python操作mysql简单版(一)

from pymysql import connect


def mysql_action(sql, params=None):
    """对mysql进行操作"""
    # 创建connection 链接
    conn = connect(host='localhost', port=3306, user='root', password='xxxx', database='xxx', charset='utf8')
    # 获取cursor 对象
    cs1 = conn.cursor()
    # 执行sql 语句
    count = cs1.execute(sql, params)

    # 获取查询的结果
    result = cs1.fetchall()

    # 提交
    conn.commit()
    # 关闭
    cs1.close()
    conn.close()
    print("执行结束。。。。。")
    return result