
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 · 703 阅读 · 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 · 1333 阅读 · 0 评论 -
sql select condition
where:[not] in ( ,)[not] between andlike '%XXX_'is NULLAND OR原创 2018-09-02 10:12:48 · 1315 阅读 · 0 评论 -
mysql select function
count sumavgmaxmin原创 2018-09-02 11:18:18 · 591 阅读 · 0 评论