mysql - Ruby:使用 set 函数时 mysql 抛出错误

Question

我确实通过 mysql2 gem 访问 mysql 数据库。

conn.query("SET @showcurrent := false; SELECT * from admins;")

抛出一个错误:

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 'SELECT * from admins' at line 1

如果我排除 set 函数，它就可以工作。如何使其与 set 函数一起使用？

conn.query("从管理员中选择 *;")

=> #<Mysql2::Result:0x00ff8557af200 @query_options={:as=>:hash, :async=>false, :cast_booleans=>false, :symbolize_keys=>false, :database_timezone=>:local, :application_timezone=>nil, :cache_rows=>true, :connect_flags=>bla, :cast=>true, :default_file=>nil, :default_group=>nil, :host=>"bla1", :username=>"bla", :password=>"bla", :database=>"bla", :port=>3007}>

Answer 1

尝试:

conn.query("SET @showcurrent = false; SELECT * from admins;")