python-mysql

from pymysql import *
import pymysql
pymysql.install_as_MySQLdb()

def main():
    # 创建 connection链接
    conn = pymysql.connect(host='127.0.0.1', port=3306, database='test', user='root', password='python', charset='utf8')
    # 获取 cursor 对象
    csl = conn.cursor()
    # 执行sql 语句
    create_table = 'create table students(id int auto_increment not null primary key,class char(20),stu_name char(20),age varchar(30));'
    query = 'insert into students(class, stu_name, age) values("3","张三","18");'

    # 如果 students 表存在，就先删除再建表
    csl.execute("DROP TABLE IF EXISTS students")

    csl.execute(create_table)

    csl.execute(query)
    # 提交之前的操作，如果之前已经执行多次的 execute，那么久都先进行提交
    conn.commit()
    # 关闭cursor 对象
    csl.close()
    # 关闭connection对象
    conn.close()


if __name__ == '__main__':
    main()

两种方法，可参考
https://blog.youkuaiyun.com/weixin_35939542/article/details/112267700