9951 explained code solutions for 126 technologies


mysqlDisable ONLY_FULL_GROUP_BY mode


SET GLOBAL sql_mode = (SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''));ctrl + c
GLOBAL sql_mode

will update configuration parameter for the whole server

@@sql_mode

will fetch the same variable current value

'ONLY_FULL_GROUP_BY', ''

will remove ONLY_FULL_GROUP_BY from sql_mode variable