mysql - 我刚刚在查询附近遇到错误语法

Question

我在 MySQL 查询中遇到错误，但我不知道它是什么

错误是

ERROR 1064 (42000): 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 'sin( radians(30.9006547) ) * sin( radians(lat itude) ) ) ,8) as distance FROM ' at line 3

查询是

SELECT h.*
     , ROUND(1.609344 * 3956 * acos( cos( radians(30.9006547) ) * cos( radians(latitude) ) * 
cos( radians(longitude) - radians(30.8524007) ) sin( radians(30.9006547) ) * sin( radians(latitude) ) ) ,8) as distance 
  FROM helper h
 where is_available = 1 
   and is_active = 1 
   and is_approved = 1 
   and ROUND((1.609344 * 3956 * acos( cos( radians(30.9006547) ) * cos( radians(latitude) ) * 
cos( radians(longitude) - radians(30.8524007) )sin( radians(30.9006547) ) * sin( radians(latitude) ) ) ) ,8) <= 60
 order 
   by distance LIMIT 3;

Answer 1

在您的代码中，您错过了 cos() 和 sin() 之间的 + 符号

  SELECT h.*
       , ROUND(1.609344 * 3956 * acos( cos( radians(30.9006547) ) * cos( radians(latitude) ) * 
  cos( radians(longitude) - radians(30.8524007) ) +  /*<<<<<< here */
  sin( radians(30.9006547) ) * sin( radians(latitude) ) ) ,8) as distance 
    FROM helper h
   where is_available = 1 
     and is_active = 1 
     and is_approved = 1 
     and ROUND((1.609344 * 3956 * acos( cos( radians(30.9006547) ) * cos( radians(latitude) ) * 
  cos( radians(longitude) - radians(30.8524007) ) + /* <<<< and here */
   sin( radians(30.9006547) ) * sin( radians(latitude) ) ) ) ,8) <= 60
   order 
     by distance LIMIT 3;