开发者

What does double "at" (@) marks mean in this SQL query?

开发者 https://www.devze.com 2022-12-24 19:16 出处:网络
I couldn\'t find anything about this in MySQL documentation. SELECT accesion_id, definition FROM accesion_table

I couldn't find anything about this in MySQL documentation.

SELECT accesion_id, 
       definition 
  FROM accesion_table 
 WHERE search_word @@ ? 开发者_运维问答OFFSET ? LIMIT Const.MAX_DISP_COUNT;


Most likely the code that is executing this sql statement has some parser that's handling this odd syntax, since the the @@, ? and Const.MAX_DISPLAY_COUNT aren't part of MySQL. Also the keyword OFFSET must be placed after the LIMIT keyword.


With Oracle the '@@' to point to the current directory of the executing file. Could it be that MySql might be following Oracles lead?

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号