Answers for "1055 expression 12 of select list is not in group by clause and contains nonaggregated column "mysql""

SQL
1

Expression number 1 of select list is not in group by clause

mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
Posted by: Guest on June-27-2020

Code answers related to "1055 expression 12 of select list is not in group by clause and contains nonaggregated column "mysql""

Code answers related to "SQL"

Browse Popular Code Answers by Language