grimzy/get_sql_mode

Last active August 2, 2017 15:57

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/grimzy/be7758f04ed909a52d3966308f1f8200.js"></script>
Save grimzy/be7758f04ed909a52d3966308f1f8200 to your computer and use it in GitHub Desktop.

Download ZIP

MySQL sql_mode

Raw

get_sql_mode

select @@sql_mode;

Raw

remove_only_full_group_by

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