Hi,
So, I can click on this particular table. But, once I click on the Data tab, HeidiSQL pops up this error message.
SQL Error (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 3.
And the log window shows this:
SHOW CREATE TABLE `fin_pro`.`att_log`;
SELECT * FROM `fin_pro`.`att_log` WHERE
LIMIT 1000;
/* SQL Error (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 3 */
But, I can display the data if I run query manually:
SELECT * FROM `fin_pro`.`att_log` LIMIT 1000;
How do I remove the offending SQL query?
Thank you Henry