MySQL - Small query issue

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

key is a reserved word in mySQL. You should use a different column name — Pekka
– Pekka, Commented Mar 22, 2011 at 18:53

ryebr3ad · Accepted Answer · 2011-03-22 18:54:37Z

1

add quotes

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

answered Mar 22, 2011 at 18:54

ryebr3ad

1,2483 gold badges12 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

brokenbeatnik · Accepted Answer · 2011-03-22 18:56:10Z

1

Are stylistqq and stqq strings? If so, they should have single quotes around them. Pekka's recommendation to use a different column name other than key is also a good idea. You can make MySQL take that string by putting backticks around it, but you'll always need them.

answered Mar 22, 2011 at 18:56

brokenbeatnik

7306 silver badges15 bronze badges

Collectives™ on Stack Overflow

MySQL - Small query issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related