circle的半径 1000和米应该怎样换算呢

digoal / blog

Opensource,Database,AI,Business,Minds. git clone --depth 1 https://github.com/digoal/blog

GNU General Public License v2.0

8.1k stars 1.9k forks source link

Open pyma95 opened 2 years ago

pyma95 commented 2 years ago

hi 请问一下下列sql语句中circle的半径 1000和米应该怎样换算呢

select * from cb where c1=0 and c2=100 and c3 <@ circle '((23,3175),1000)' order by c3 <-> point(23,3175) limit 1000;