SQL Mode not changing
Posted by: kasper (---.tpgi.com.au)
Date: June 26, 2016 03:37AM

Hey,

So I'm running wamp 3 (64-bit) on a Windows Server 2012 R2

I'm trying to set the sql-mode to: TRADITIONAL,ALLOW_INVALID_DATES in the my.ini file and through command
but still isnt changing at all when I do
SELECT @@GLOBAL.sql_mode;

MySQL version is 5.7.9

Can someone help out <3

Options: ReplyQuote
Re: SQL Mode not changing
Posted by: Otomatic (Moderator)
Date: June 26, 2016 09:52AM

Hi,

TRADITIONAL is not a valid value! [dev.mysql.com]

Just put
sql_mode=""

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote


Sorry, only registered users may post in this forum.