通过MySQLdb创建函数

import MySQLdb

# 连接数据库
db = MySQLdb.connect(host="localhost", user="root", passwd="password", db="test")

# 创建游标
cursor = db.cursor()

# 定义存储过程
def create_procedure(name, params):
    cursor.execute("CREATE PROCEDURE {} {}".format(name, params))

# 调用存储过程
def call_procedure(name, args):
    cursor.callproc(name, args)

# 示例：创建一个简单的存储过程
create_procedure("add_numbers", "(a INT, b INT, OUT c INT) BEGIN SET c = a + b; END")

# 示例：调用存储过程
args = (2, 3, 0)
call_procedure("add_numbers", args)

# 获取存储过程的输出参数
cursor.execute("SELECT @_add_numbers_2")
result = cursor.fetchone()
print("Result:", result[0])

# 关闭数据库连接
db.close()

pip install mysqlclient