An sql-method with a limit statement gives syntax error:
select * from theTable limit 5
Error, _mysql_exceptions.ProgrammingError: (1064, "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 'LIMIT 1000' at line 1")
Exactly the same statement works as expected in a mysql prompt.
Is there a way make zmyslqlda accept limit?
Flemming
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
An sql-method with a limit statement gives syntax error:
select * from theTable limit 5
Error, _mysql_exceptions.ProgrammingError: (1064, "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 'LIMIT 1000' at line 1")
Exactly the same statement works as expected in a mysql prompt.
Is there a way make zmyslqlda accept limit?
Flemming