MySQL Forums
Forum List  »  Connector/Python

Setting up stored functions from python
Posted by: Grant Paton-Simpson
Date: August 20, 2007 03:16PM

I wrote a stored function which works when added directly to MySQL. But I didn't want to have to manually add it to my system - ideally I wanted to do it through python. Unfortunately, I was never able to get the DELIMITER command working via the MySQLdb cursor execute method.

e.g.

set_del = "DELIMITER $$"
cursor.execute(set_del)

returns a bad syntax warning from MySQL.

Is there another way of doing this?



Edited 1 time(s). Last edit at 08/20/2007 03:19PM by Grant Paton-Simpson.

Options: ReplyQuote


Subject
Written By
Posted
Setting up stored functions from python
August 20, 2007 03:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.