升级到MYSQL8后的宽松模式

关闭全部

运行 SET GLOBAL sql_mode='';

或者单关闭 ONLY_FULL_GROUP_BY
MariaDB [kalacloud_demo]> SET GLOBAL sql_mode='STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,TRADITIONAL,NO_ENGINE_SUBSTITUTION';