sql-mode=“NO_ENGINE_SUBSTITUTION” permanent in MySQL my.cnf

Veröffentlicht:
Aleksandar Stajić
Aktualisiert am: 20. September 2018 um 15:36
SET GLOBAL sql_mode = 'NO_ENGINE_SUBSTITUTION';
SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION';
in /etc/mysql/my.conf: sql-mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
services mysql restart