207 A Block, Lake Point Towers, LPT Avenue Road, Bengaluru 560068

MySQL – Disable Full Group By

Encountered the exception : java.sql.SQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘IAM_DB.this_.ID’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. Fix was to update global settings in MySQL In MySQL SELECT @@sql_mode; +——————————————————————————————————————————————-+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +——————————————————————————————————————————————-+ Change […]

Read More »

MySQL 5.6/7 on Debian 7.x

Debian 7.6 was installed on the VM.  Default mysql-server which was getting installed using apt-get was 5.5.  One of the updates in mysql 5.6 was to support more than one current_timestamp column with default value of current time stamp. So to install this is what I did wget http://dev.mysql.com/get/mysql-apt-config_0.3.5-1debian7_all.deb dpkg -i mysql-apt-config_0.3.5-1debian7_all.deb apt-get update apt-get […]

Read More »