mysqli - simple update syntax error mysql -


here update string. cannot figure out syntax error though pretty simple query.

update building set building_name='1901' building_lead_user='29' building_maint_user='23' building_id='4' limit 1

building

field type allow null default value building_id int(6) no
building_name varchar(30) yes building_lead_user int(6) yes building_maint_user int(6) yes status int(1) unsigned zerofill yes

you're missing commas separate fields you're updating:

update building set building_name='1901', building_lead_user='29', building_maint_user='23' building_id='4' limit 1 

Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -