To disable the ONLY_FULL_GROUP_BY mode in MySQL, you can use the following steps:
- Open the MySQL configuration file (my.cnf or my.ini, depending on your operating system).
Add the following line to the [mysqld] section of the configuration file:
sql_mode = ''
- Save the changes to the configuration file and exit the text editor.
- Restart the MySQL server for the changes to take effect.
Alternatively, you can also disable ONLY_FULL_GROUP_BY by running the following command in the MySQL client:
SET sql_mode = '';
This will disable ONLY_FULL_GROUP_BY for the current MySQL session. To make the change permanent, you will need to modify the MySQL configuration file as described above.