mysqlDisable ONLY_FULL_GROUP_BY mode
SET GLOBAL sql_mode = (SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));ctrl + cGLOBAL sql_modewill update configuration parameter for the whole server | @@sql_modewill fetch the same variable current value |
'ONLY_FULL_GROUP_BY', ''will remove | |
More of Mysql
- Select last record from group
- Insert/update multiple rows in single query
- What is the LONGTEXT column max size (length) in Mysql
- Create myisam tables dump without locking tables
- Truncate all tables in a specific database
- What is the TINYTEXT column max size (length) in Mysql
- Create dump of a database to a filename with date
- How to find duplicate varchar/text column values in table
- What is the MEDIUMTEXT column max size (length) in Mysql
See more codes...