The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

Specific terminal command ONLY_FULL_GROUP_BY & ANSI_QUOTES

Hi I only have minimal knowledge on this but I would need to do the following. The generic instruction I have is for MySql MySQL - The SQL mode "ONLY_FULL_GROUP_BY", and the setting "ANSI_QUOTES", must be disabled.

But I am on MariaDb

What would be the Mariadb command equivalent to 1. verify the current status 2. Change it if needed.

I would need the terminal command as I do not use PHPMyAdmin or the likes. This is on a production self-managed LEMP VPS

Thanks folks

Answer Answered by Ian Gilfillan in this comment.

These are two SQL_MODE settings, and neither are enabled by default in MariaDB. See SQL_MODE and Configuring MariaDB with Option Files for more details.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.