Calling a stored procedure in Python : Python « Procedure Function « SQL / MySQL

1. SQL / MySQL
2. Procedure Function
3. Python

Calling a stored procedure in Python

 
try:
              conn = MySQLdb.connect (host = 'localhost', user = 'root', passwd = 'pass', db = 'prod',
                            port=3306)
              cursor1=conn.cursor()
              cursor1.execute("CALL error_test_proc()")
              cursor1.close()
              
       except MySQLdb.Error, e:
              print "Mysql Error %d: %s" % (e.args[0], e.args[1])

        

Related examples in the same category