Home / server / Questions / 436724
In Process
User4283
Asked: 2012-10-11 00:53:30 +0800 CST

Why can't I select from a table named range without using backticks?

  • 772

I'm facing a problem with mysql. A query select * from range; works on mysql 5.0.22 but does not work mysql 5.1.61. but it works with backtick: i.e. 

select * from `range`;

Kindly help in this regard.

I want mysql 5.1.61 to execute the query without backtick (`)

linux

1 Answers

  1. range is a reserved word in 5.1

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

    So if you use it, you need to use the back ticks in order to tell mysql that you aren't using the reserved word. range wasn't in 5.0

    • 3