Rails模型中Mysql归档关键字

Question

现在我有了一个 Controller :

class CommonController < ApplicationController
  def location
    @locations=Location.select(:key)
    render json: @locations
  end
end

我的数据库是mysql，key是mysql关键字。

但是我的表有一个名为key的文件

当我运行该操作时，我收到错误:

Mysql2::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 'key FROM `locations`' at line 1: SELECT key FROM `locations` 

那我该怎么办？

Answer 1

我明白了。就这样写:

@locations=Location.select('`key`')