MrWeb/nonaggregated.sh

Created October 13, 2019 07:20

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/MrWeb/a5ec0513c583072c0e8e368bf9185455.js"></script>
Save MrWeb/a5ec0513c583072c0e8e368bf9185455 to your computer and use it in GitHub Desktop.

Download ZIP

Fix nonaggregated MySQL GROUP BY local machine

Raw

nonaggregated.sh

mysql -uroot -e "SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment