MySql
路口游子
本博客仅供免费阅读,不提供咨询服务,请勿私信。
展开
-
MBRINTERSECTS
'root@localhost:test>'select ogr_fid, astext(shape) from tuku where ogr_fid = 37341; +---------+---------------------------------------------------------------------------------+ | ogr_fid | astext...原创 2018-07-19 22:33:09 · 679 阅读 · 0 评论 -
MBRContains
'root@localhost:test>'set @polygon = GeomFromText('Polygon((4008.32004 -61.66346, 4008.32004 -65.68119, 8646.72582 -64.37436, 8711.85165 -41.26169, 4008.32004 -61.66346))'); Query OK, 0 rows ...原创 2018-07-20 02:00:37 · 1292 阅读 · 0 评论 -
sql select condition
where: [not] in ( ,) [not] between and like '%XXX_' is NULL AND OR原创 2018-09-02 10:12:48 · 1279 阅读 · 0 评论 -
mysql select function
count sum avg max min原创 2018-09-02 11:18:18 · 558 阅读 · 0 评论