MySQL - 小查询问题

Question

I have a problem with a small query. When I execute it I am getting a error which is

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'key=stqq WHERE id=75' at line 1

My query is as follows

UPDATE roles SET name=stylistqq, key=stqq WHERE id=75

Answer 1

add quotes

UPDATE roles SET name='stylistqq', key='stqq' WHERE id=75