My SQL queries fail; SQLyog View Data queries work

[bfalling]

I'm getting a bug in SQLyog Enterprise 4.01BETA (downloaded 1/31/2005), where typing the following query by hand in the SQL Query pane,

select * from `forumusa`.`mst_profile_candidate` limit 0, 1000

generates an error:

Code:

Error Code : 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 'select * from `forumusa`.`mst_profile_candidate` limit 0, 1000

(0 ms taken)

whereas selecting “View Data” on the same table, which generates the EXACT same SQL string (as viewed in the SQL Query pane) executes just fine.

Even stranger, if I go back and edit either line in the SQL Query pane, such as adding additional WHERE conditions, NOTHING works on the line I had typed, and EVERYTHING works on the SQLyog generated line. I can even copy and paste the exact same text from the SQLyog generated line into the line I typed and the error will still be generated.

Thanks!

[Ritesh]

Can you post a screenshot of your query pane with both the queries?

[Author]

Posts