![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库查询
文章平均质量分 88
nymph94
这个作者很懒,什么都没留下…
展开
-
数据库报错: Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column
数据库操作出错 操作语句: TRUNCATE contract_ele; 错误信息: [SQL]TRUNCATE contract_ele; 受影响的行: 0 时间: 0.156s [Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'information_schema.PROFILING.SEQ' which is not functiona原创 2020-07-07 17:26:18 · 1295 阅读 · 0 评论 -
mysql 空间查询错误:GeometryFromText does not exist
GeometryFromText 不存在或者语法错误 错误信息例如: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION erp_php.GeometryFromText does not exist (SQL: insert into `contract_ele_area` (`prov_ext_id`, `city_ext_id`, `area_ext_id`, `is_sole`, `agent_level`, `proje原创 2020-07-07 16:49:51 · 1408 阅读 · 0 评论 -
mysql 地理位置查询
mysql空间扩展 mysql 官方指南为 GLength(LineStringFromWKB(LineString(point1, point2))) 首先创建位置表结构 CREATE TABLE `locationpoint` ( `id` int(11) NOT NULL, `pt` point NOT NULL, `province` varchar(20) NOT NULL, `city` varchar(20) NOT NULL, `longitude` double(1原创 2020-06-23 14:28:15 · 1620 阅读 · 0 评论