Improve your programming skills

Python – MySQL Procedure execution

using mysql-connector-python package

from db_works import db_connect

# view also need to be locked
def call_procedure(): 
    cursor.execute("CALL `procedure_schema.procedure_name`();")


if __name__ == "__main__":
    # connect to db
    cursor, cnxn = db_connect()

    call_procedure()

Leave a comment

Your email address will not be published. Required fields are marked *