MySQL Syntax with DELETE FROM?

Question

I have this bit of SQL that always returns an error, though I can't find why it is returning the error. I have connected to the database with no errors. I'm running PHP 5.2.17, MySQL 5.5.25a, and Apache 2.4.2.

The SQL:

DELETE FROM mail WHERE to=1

The error:

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

Dupe of Yii Framework/PDO getting error CDbCommand failed to execute the SQL statement: SQLSTATE[42000], SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax and others. — outis
– outis, Commented Jul 17, 2012 at 2:03

Wiseguy · Accepted Answer · 2012-07-17 01:59:57Z

6

TO is a reserved word, you need to use backticks:

 DELETE FROM mail WHERE `to` = 1

edited Jul 17, 2012 at 1:59

Wiseguy

20.9k9 gold badges68 silver badges83 bronze badges

answered Jul 17, 2012 at 1:59

No Results Found

103k38 gold badges199 silver badges232 bronze badges

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

3 Comments

Cole Tobin Over a year ago

you should be able to see it as it is highlighted :)

DerekAthley Over a year ago

Thank you, that worked. I didn't know it was reserved xD I was running it from a PHP file, so the query was enclosed in quotations.

No Results Found Over a year ago

It's a good habit to use backticks anyways, and quote your values (which I didn't do in the example). The query actually isn't executed with quotations, that's just PHP syntax. You may click the checkmark to the left to mark your question as resolved if you wish.

Ambrose · Accepted Answer · 2012-07-17 02:24:33Z

0

By adding backticks on the column name escapes in from MySQL Reserved Word

DELETE FROM mail WHERE `to`=1

answered Jul 17, 2012 at 2:24

Ambrose

5213 silver badges13 bronze badges

Comments

NewInTheBusiness · Accepted Answer · 2012-07-17 01:58:42Z

-1

if the column to is not e.g. INT or DEC you should make it to = "1"

answered Jul 17, 2012 at 1:58

NewInTheBusiness

1,4501 gold badge9 silver badges14 bronze badges

Collectives™ on Stack Overflow

MySQL Syntax with DELETE FROM?

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related