소질없는 개발/Mysql
Geometry 타입 - POINT
Geometry 컬럼 생성 (Mysql)CREATE TABLE table_for_geo ( column_for_point point) 데이터 삽입INSERT INTO table_for_geo (column_for_point) VALUES (ST_GeomFromText('POINT(127.0 37.0)'));// POINT 좌표 사이에 콤마 없음 주의!데이터 조회SELECT ASTEXT(column_for_point) FROM table_for_geo; 반경 검색SELECT * FROM table_for_geoWHERE ST_Distance_Sphere(column_for_point, ST_GeomFromText('POINT(127.0 37.0)'))