Error no. 1064

[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.

Thanks

[Ritesh]

SQLyog logs all its queries in the History window. Just paste the query out here.

If you are using SQLyog 2.51, we highly recommend you to upgrade to 3.52 as it has many new features and lot of big fixes.

[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

[Ritesh]

Aha…found the error !!!!

Your database name contains spaces, therefore you need to put ticks(`) around it.

Code:

select info from peace beanies.properties where id='1'

will not work. Try

Code:

select info from `peace beanies`.`properties` where id='1'

HTH

[Ritesh]

BTW, SQLyog puts ticks around all object names in the SQL it generates.

[Author]

Posts