could you kindly advise me how to solve the problem (MySQL5.1.41, python 2.6.4
r264:75708)
My stored procedure return 3000 over records, I had following error
db.execute(sql_query)
File "C:\Python26\lib\site-packages\pymysql-0.2-py2.6.egg\pymysql\cursor.py",
line 82, in execute
self.errorhandler(self, exc, value)
File "C:\Python26\lib\site-
packages\pymysql-0.2-py2.6.egg\pymysql\connections.py", line 96, in
defaulterrorhandler
raise errorclass, errorvalue
<class 'pymysql.exceptions.ProgrammingError'="">: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'call item_date()' at line
I can execute the stored procedure without problem in MySQLWorkbench 5.21
I don't have any syntax error on SQL.
If I execute the same Stored Procedure which return less than 1000 records, I
have no problem
I have tested client_flag=CLIENT_MULTI_RESULTS in connection but no
difference.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
could you kindly advise me how to solve the problem (MySQL5.1.41, python 2.6.4
r264:75708)
My stored procedure return 3000 over records, I had following error
db.execute(sql_query)
File "C:\Python26\lib\site-packages\pymysql-0.2-py2.6.egg\pymysql\cursor.py",
line 82, in execute
self.errorhandler(self, exc, value)
File "C:\Python26\lib\site-
packages\pymysql-0.2-py2.6.egg\pymysql\connections.py", line 96, in
defaulterrorhandler
raise errorclass, errorvalue
<class 'pymysql.exceptions.ProgrammingError'="">: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near 'call item_date()' at line
I can execute the stored procedure without problem in MySQLWorkbench 5.21
I don't have any syntax error on SQL.
If I execute the same Stored Procedure which return less than 1000 records, I
have no problem
I have tested client_flag=CLIENT_MULTI_RESULTS in connection but no
difference.
And your MySQLdb version is...? It can't really be 0.2... You seem to be using
http://pypi.python.org/pypi/PyMySQL/0.2 which is some other module.