MySQL 5.7 SQL Modes sql_mode Default SQL mode NO_ENGINE_SUBSTITUTION From 5.7.5 ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES From 5.7.7 NO_AUTO_CREATE_USER From 5.7.8 NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ZERO_IN_DATE Set sql_mode in my.cnf sql-mode="value1,value2" dynamic SET GLOBAL sql_mode = 'modes'; SET SESSION sql_mode = 'modes'; Full List of SQL Modes (based on 5.7.23) Strict SQL mode STRICT_ALL_TABLES - Enab.. 더보기 이전 1 2 3 4 5 6 ··· 349 다음