[mark]

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

[Author]

Posts