用PYTHON ,DJANGO 做站，在通常的情况下，需要用到 orM 的查询方法，比如object.filter(tag__contains=‘keywords‘)....在这种情况下，如果你跟踪 sql 语句，你会发现，SQL 语句会生成 select .... like bianry ‘%keywords%‘, 如果是这样的语句，在某些情况是下是会出问题的，也就是说查询出来的数据可能会比你预计的少。如果你用 raw sql 查总数 select count(*) from table where like ‘%keywords%‘ 得到数量可能比你用ORM ...
今天，公司新购买了云服务器，要部署测试环境，测试时发现开发环境没问题，但测试环境却报错了，打开日志分析错误原因，原来时mysql5.7版本的sql_model默认配置了ONLY_FULL_GROUP_BY的原因。完整错误日志如下：
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘yb_platform_audit...
- Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ‘ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
sudo vim /etc/mysql/conf.d/mysql.cnf
[mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE...
2、当前操作的数据切换成 mysql
3、执行 SELECT @@global.sql_mode
4、执行 SET GLOBAL sql_mode=‘NO_ENGINE_SUBSTITUTION‘;
成功解决。【MySQL】出现“SELECT list is not in GROUP BY clause and contains xxx”错误提示标签：成功 global sel 数据库 客户 连接 span sele sql 本文系统来源：http://www.cnblogs.com/jiuxuan/p/7567606.html
我","想","销","存单"),keywords->‘$.keywords‘) ORDER BY weights DESC;
即可搜索到数据 另附上部分sql，以防之后忘记
SELECT * FROM nlu_define_table;
SELECT * FROM nlu_define_table WHERE keywords LIKE "%销%";
SELECT * FROM nlu_define_table WHERE JSON_EXTRACT(keywords,‘$.keywords‘) LIKE "%销%";
SELECT * FROM nlu_define_table WHERE keywords -> ‘$.keywords‘ LIKE "%销%";其中第三条sql和第四条sql是等效...
:Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘ppm_c.ppm_flow_starting_dealing.status‘ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by mysql问题解决SELECT list is not in GROUP BY clause and contains nonaggregated column标签：题解 部署 class tin dep sql contains ati...
报错如下：
Expression #2 of SELECT list is not in GROUP BY clause and contains
nonaggregated column ‘sss.month_id’ which is not functionally
dependent on columns in GROUP BY clause; this is incompatible with
sql_mode=only_full_group_by
问题出现的原因： MySQL 5.7.5及以上功能依赖检测功能。如果启用了ONLY_FULL_GROUP_BY SQL模式（默认情况下），MySQL将拒绝选择列表，HAVING条件或ORDER BY列表的查询引用...
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘rpacloudsit.t.app_id‘ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
MySQL有any_value(field)函数，他主要的作用就是抑制ONLY_FULL_GROUP_BY值被拒绝
官方有介绍，地址：https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions....
global sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION‘;
set session sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION‘;修改配置文件，在my.cnf配置中去掉“only_full_group_by ”即可，修改后，需要重启mysql。如下：sql_mode=‘STRICT_TRANS_TA...
原因 聚合查询出现这样的报错是因为mysql设定的mode含有 ONLY_FULL_GROUP_BY1mysql> select @@sql_mode;+-------------------------------------------------------------------------------------------------------------------------------------------+| @@sql_mode |+-------------------...
SET @x = 121;
SET @y = 30;
-- SET @point = CONCAT(‘POINT(‘,@x,‘ ‘,@y,‘)‘);
set @point= Point(@x,@y);
set @geometry=ST_GeomFromText(‘POLYGON((121.044 30.594, 121.046 30.59, ..., 121.046 30.5948, 121.044 30.594))‘);
SELECT ST_Contains(@geometry,@point);//面包含点
SELECT ST_Within(@point, @geometry);//点在面https://blog.csdn.net/zshtiger2414/article/details/77975958
https://dev.mysql.com/d...
https://blog.csdn.net/weixin_42409107/article/details/100074210
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘x.xxx‘ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
原因是：
MySQL 5.7.5及以上实现了对功能依赖的检测。如果启用了only_full_group_by SQL模式(在默认情况下是这样)，那么MyS...
- Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘xt_sc.t_comment.content‘ which is not
functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
执行的sql语句
SELECT n.id,n.title,n.qq,u.username,c.content,c.create_time
FROM `t_need` AS `n`
LEFT JOIN `t_users` `u` ON `n`.`user_id`=`u`.`id`
INNER JOI...
1. 查询住址在北京的学生 SELECT student_id,student_name FROM students WHERE CONTAINS( address, beijing ) remark: beijing是一个单词，要用单引号括起来。 2. 查询住址在河北省的学生 SELECT student_id,student_name FROM students WHERE CONTAINS(1. 查询住址在北京的学生
SELECT student_id,student_name
FROM students
WHERE CONTAINS( address, beijing )
remark: beijing是一个单词，要用单引号括起来。
2. 查询住址在河...
本文主要介绍了Oracle 中Contains 函数的用法，查询地址在某个城市的学生，sql语句给大家介绍的非常详细,需要的朋友可以参考下，希望能帮助到大家。1. 查询住址在北京的学生SELECT student_id,student_name
FROM students
WHERE CONTAINS( address, beijing )remark: beijing是一个单词，要用单引号括起来。2. 查询住址在河北省的学生SELECT student_id,student_nameFROM students
WHERE CONTAINS( address, "HEIBEI province" )re...
