MySQL Error 1064 (42000) when running UPDATE query -

can tell me wrong mysql query?

query:

update material_master set mst_name='xxx' mat_desc='yyy' mat_type='raw material' mat_grp='h' uom='kg' currency='inr' entity_assembled='a' idmaterial_master=3; 

error:

1064 (42000): have error in sql syntax; check manual corresponds mysql server version right syntax use near 'mat_desc='yyy' mat_type='raw material' mat_grp='h' uom='kg' currency='inr' entit' @ line 1

in this:

update material_master  set mst_name='xxx' mat_desc='yyy'  mat_type='raw material'  mat_grp='h' uom='kg' currency='inr' entity_assembled='a' idmaterial_master=3; 

you're missing commas between fields in set zone.

the correct query is:

update material_master  set mst_name='xxx', mat_desc='yyy',  mat_type='raw material',  mat_grp='h', uom='kg', currency='inr', entity_assembled='a' idmaterial_master=3;