Cannot insert string into MySQL text column [duplicate]

Question

For some reason, my queries screw up when I write to a column of type "text". Here is an example:

Describe messages; Field Type Null Key Default Extra id int(11) NO PRI NULL auto_increment title varchar(255) YES NULL body text YES NULL to text YES NULL content_type varchar(255) YES NULL is_sms tinyint(1) YES NULL user_id int(11) YES NULL created_at datetime YES NULL updated_at datetime YES NULL

Then I try an insert:

INSERT INTO messages (id,title,body,to) VALUES ('1','Test Message','This is a test message. This is a test message. This is a test message. This is a test message.', 'an email' );

For some reason this causes a general MySQL syntax error. The query works fine if I remove the "to" column and it's corresponding value from the query.

Any ideas?

score 9 · Accepted Answer · 2009-04-15 15:43:32Z

'to' is a reserved keyword in MySQL. You'll need to rename your column.

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

However, Reserved words are permitted as identifiers if you quote them.

http://dev.mysql.com/doc/refman/5.1/en/identifiers.html

Ólafur Waage · Accepted Answer · 2009-04-15 15:40:21Z

Try this instead

INSERT INTO messages (`id`,`title`,`body`,`to`) VALUES ('1','Test Message','This is a test message. This is a test message. This is a test message. This is a test message.', 'an email' );

Quassnoi · Accepted Answer · 2009-04-15 15:39:38Z

INSERT INTO messages (id,title,body,`to`) VALUES ('1','Test Message','This is a test message. This is a test message. This is a test message. This is a test message.', 'an email' );

itsmatt · Accepted Answer · 2009-04-15 15:42:36Z

I believe if you surround the "to" with backtics like so:

INSERT INTO messages (id,title,body,`to`) VALUES ('1','Test Message','This is a test message. This is a test message. This is a test message. This is a test message.', 'an email' );

it will work - did for me anyway.

huseyin · Accepted Answer · 2013-07-16 13:02:28Z

Use a variable is not defined in MySQL; for example : not use 'to', 'not', 'join' ...

INSERT INTO messages (id,title,body,test) VALUES ('1','Test Message','This is a test message. This is a test message. This is a test message. This is a test message.', 'an email' );

Collectives™ on Stack Overflow

Cannot insert string into MySQL text column [duplicate]

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Related