#ei-capitan

[cmthakur]

Fix MySql group_by after upgrading mysql

Fix MySql group_by after upgrading mysql

MySql version 5 contains breaking changes among which default SQL mode is one of them. The new default SQL mode includes these modes: 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. Brief on new changed modes ONLY_FULL_GROUP_BY and STRICT_TRANS_TABLES modes were added in MySQL 5.7.5 NO_AUTO_CREATE_USER…

View On WordPress