Check the SQL mode "sql_mode"

To check the value of SQL mode "sql_mode", check the global variable "sql_mode".

select @@GLOBAL.sql_mode;

This is an example of the output SQL mode.

STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION

Please also refer to the following articles regarding the SQL mode "sql_mode".

MariaDB Tutorial