python使用pymysql库操作mysql

安装pymysql第三方包:

sudo pip3 install pymysql

脚本模板如下：

# -*- coding: utf-8 -*-
# create_user：user_san
# create_time：2021/6/14 11:24
import time
import pymysql
import requests

# 数据库配置
db_host = 'localhost'
port = 3306
db = 'python_test_1'
user = 'root'
pwd = 'mysql'


def select_fun(my_db):
    # 创建游标 my_cursor
    my_cursor = my_db.cursor()

    a = "男"
    # sql = "select id, name from students where gender = '%s';" % (a,)  # 如果拼接的是字符串，%s需要加引号
    sql = "select * from students where id=1;"
    result = my_cursor.execute(sql)
    print(result)  # 输出执行的个数

    # 输出找到的全部数据(元组套元组)   ((3, '彭于晏'), (4, '刘德华'))
    res = my_cursor.fetchall()
    data = res[0]

    print(data)
    insert_sql = "update students set gender = '%s' where id =1" % (a,)

    print(insert_sql)
    my_cursor.execute(insert_sql)

    # 输出找到的第一条数据(元组)  (3, '彭于晏')
    # res = my_cursor.fetchone()

    # 如果是update或insert操作，需要commit
    my_db.commit()

    my_cursor.close()
    return result


def main():
    """主程序入口"""
    print("="*20, "begin", "="*20)
    my_db = pymysql.connect(host=db_host, port=port, user=user, password=pwd, database=db,
                            charset="utf8")
    select_fun(my_db)
    print("="*20, "end", "="*20)


if __name__ == '__main__':
    main()