How to./MySQL (3) 썸네일형 리스트형 this is incompatible with sql_mode=only_full_group_by java.sql.SQLSyntaxErrorException: In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'aaaaaa'; this is incompatible with sql_mode=only_full_group_by mysql 버전 5.6 이상 에러 발생 SELECT @@sql_mode; ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION 세션 수정 SET SESSION sql_mode = 'STRICT_TRANS_T.. MySQL 사용자 패스워드 변경 ALTER USER 'pcidb'@'%' IDENTIFIED BY 'New Password'; flush PRIVILEGES; Mysql 컬럼명으로 테이블 찾는방법 SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='컬럼명' 이전 1 다음
