Mysql: Difference between revisions
No edit summary |
|||
| Line 10: | Line 10: | ||
http://stackoverflow.com/questions/23921117/disable-only-full-group-by | http://stackoverflow.com/questions/23921117/disable-only-full-group-by | ||
* rewrite query with ANY_VALUE(column) | * rewrite query with ANY_VALUE(column) | ||
* disable: SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); | * disable: | ||
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); | |||
http://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html | http://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html | ||
"In MySQL 5.7.5 and higher, ONLY_FULL_GROUP_BY also affects handling of queries that use DISTINCT and ORDER BY" | "In MySQL 5.7.5 and higher, ONLY_FULL_GROUP_BY also affects handling of queries that use DISTINCT and ORDER BY" | ||
Revision as of 2017-01-10T04:25:47
natural sort order by cast(substr(album_name,1,2))
- the +0 way http://blog.feedmarker.com/2006/02/01/how-to-do-natural-alpha-numeric-sort-in-mysql/
- doesnt work
MySQL 5.7.5 - ONLY_FULL_GROUP_BY
http://stackoverflow.com/questions/23921117/disable-only-full-group-by
- rewrite query with ANY_VALUE(column)
- disable:
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',));
http://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html "In MySQL 5.7.5 and higher, ONLY_FULL_GROUP_BY also affects handling of queries that use DISTINCT and ORDER BY"