Mysql syntax seems correct

Question

So... I received:

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 = '48f9f4a3f5e10c63804400f320f46e26'' at line 1

and so I reflected it back to myself, on the webpage and it reads:

SELECT * FROM email_confirm WHERE email = '[email protected]' AND key = '48f9f4a3f5e10c63804400f320f46e26'

I don't see the issue.

MySQL version is 5.1.65-cll

Answer: KEY is a reserved word in mysql. Need backticks !

Anton · Accepted Answer · 2012-12-11 22:52:29Z

1

key is a MySQL keyword. Since it's also the name of your field, enclose it with the appropriate symbols:

SELECT * FROM `email_confirm` WHERE `email` = '[email protected]' AND `key` = '48f9f4a3f5e10c63804400f320f46e26';

answered Dec 11, 2012 at 22:52

Anton

4,02829 silver badges40 bronze badges

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

4 Comments

Anton Over a year ago

Gotta love it when two people answer 15 seconds apart!

daevski Over a year ago

I feel like I should have thought about that more. I thought it, but ignored the thought (and forgot about it). Thank you Anton!

Anton Over a year ago

No problem! Don't forget to choose an answer, it helps our reps :)

daevski Over a year ago

Had to wait the default 10 mins! Get me some rep too. I'm new to stackoverflow! (Greatly Appreciated)

schtever · Accepted Answer · 2012-12-11 22:51:57Z

1

Key is a reserved word. Use backticks to escape it.

... `key` = '48f9...'

answered Dec 11, 2012 at 22:51

schtever

3,25019 silver badges25 bronze badges

1 Comment

daevski Over a year ago

And Thank you. Anton appeared first on the page :-\ haha

Martin Walter · Accepted Answer · 2012-12-11 22:53:47Z

1

I think key is a reserved word. Use `key` instead.

answered Dec 11, 2012 at 22:53

Martin Walter

5406 silver badges13 bronze badges

Collectives™ on Stack Overflow

Mysql syntax seems correct

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related