Error reads “you have an error in your sql syntax near .'properties when id='00000000001' at line 1…”
Line 1 id record is also autoincrement and is also primary key. Error occurs when clicking on a text entry in the inserting/update data dialogue box.
Knowledge of sqlyog 2.51 is basic and sql more so, so please give step by step instructions.
[16:14:11][10 ms] show databases
[16:14:11][0 ms] use `peace beanies`
[16:14:14][0 ms] show table status from `peace beanies`
[16:14:14][0 ms] show table status from `peace beanies`
[16:14:21][10 ms] show fields from `peace beanies`.`properties`
[16:14:21][0 ms] show keys from `peace beanies`.`properties`
[16:14:21][10 ms] select * from `peace beanies`.`properties` limit 0, 50
[16:14:23][0 ms] select info from peace beanies.properties where id='1'
thanks