mysql - Error 1064 when updating a table -


when updating table error:

my table speech

values:

no  speec   check 1   45      0 

and structure :

1 -no   int(100)            no  none    auto_increment  browse distinct values  change  drop    primary     unique  index   fulltext  2- speec    varchar(100)    latin1_swedish_ci       no  none        browse distinct values  change  drop    primary     unique  index   fulltext  3 - check   int(100)            no  none        browse distinct values  change  drop    primary     unique  index   fulltext 

when updating using command :

update speech set check=1 no=1 

i error:

1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'check=1 no=1' @ line 1

please me in issue

check reserved, word http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

you need escape using backtics as

update speech set `check`=1 no=1 

Comments

Popular posts from this blog

c++ - Delete matches in OpenCV (Keypoints and descriptors) -

java - Could not locate OpenAL library -

sorting - opencl Bitonic sort with 64 bits keys -