disable mysql ONLY_FULL_GROUP_BY

i have some prolem with sql mode ONLY_FULL_GROUP_BY how i permanent disable this mode

4 Replies

nebula•3y ago

cant help when you provide zero info about the problem

knuOP•3y ago

this proof of error

knuOP•3y ago

im use this query to handle error SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','')); but after restart sql_mode rollback to default

knuOP•3y ago

and this proof my query

Railway Join

Hang out with other likeminded developers & talk about all things https://railway.app on the Railway Community Server.

25KMembers

View on Discord

Want results from more Discord servers?

Add your server

Gaming

Programming

disable mysql ONLY_FULL_GROUP_BY