MySQL Syntax Error - but I can't find it

Question

INSERT INTO mo_received 
(appid, msg, to, from, operator, keyword, smsid, udh, response, created) 
VALUES 
('13846', 'HELLO', '123456789', '987654321', 
'SKTELECOM', 'Cheese', 'MESSAGE', 'UDHSTUFF', '', NOW());

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 'to, from, operator, keyword, smsid, udh, response, created) VALUES ('13846', 'HE' at line 1

That's the error I get.

Strange thing is that if I remove the "to" and "from" fields and values the insert works ok. But I don't see anything wrong with those fields.

Any ideas?

I think to and from are reserved keywords in my sql, use backticks: (appid, msg, to, from, operator, keyword, smsid, udh, response, created) — Andreas Wong
– Andreas Wong, Commented Apr 25, 2012 at 2:27
Suggest you change the name of the field "from" it's a reserved word in SQL. It's just going to cause you trouble. I'd call it "msgfrom" or similar. — GregHNZ
– GregHNZ, Commented Apr 25, 2012 at 2:29

tosin · Accepted Answer · 2012-04-25 03:29:03Z

2

"to" and "from" are not recommended for column name. It's reserved.
http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

If you use reserved column name, surround with reverse single quote.

INSERT INTO mo_received (appid, msg, `to`, `from`, operator, keyword, smsid, udh, response, created)

edited Apr 25, 2012 at 3:29

answered Apr 25, 2012 at 2:27

tosin

1,1797 silver badges14 bronze badges

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

Comments

user1032531 · Accepted Answer · 2012-04-25 02:27:34Z

1

See http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

answered Apr 25, 2012 at 2:27

user1032531

26.5k77 gold badges248 silver badges422 bronze badges

Collectives™ on Stack Overflow

MySQL Syntax Error - but I can't find it

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