Hi,
I love SQLYog a lot and it feels great to work with it. I have installed SQLYog community edition version 6.13 (final) to work with mysql 5.0.41. I encountered a syntax error prompt when I was trying to add a new field with comments. Here are the steps to reproduce the error:
a) Create a table named test1 with some fields.
😎 In the object browser, select test1 and right click on mouse button.
c) Select “Alter Table…” and then add a new field to test1.
d) Type some comments under the Comment column for this new field.
e) Click the Alter button.
Whenever I do this everytime, I encountered MySQL Error with error number 1064. The error description is something like this:
” 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 'after ``' at line 2.
From the error prompt, I found this sql statement generated:
alter table `ips`.`table1` add column `dafad` bit NULL COMMENT 'stest',
after `password`
Please help me to fix this error. Thank you 🙂
