Solve the problem of grouping error expression #1 of select list is not in group for MySQL greater than version 5.7

implement

set @@global.sql_mode ='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

Execute this sentence mysql8 above without No_ AUTO_ CREATE_ USER

Similar Posts: