WampServer
Apache, PHP, MySQL on Windows
Home forum
Back to WampServer
presentation
Downloads
Addons
Trainings
Alter Way
Go to Topic:
Previous
•
Next
Go to:
Forum List
•
Message List
•
New Topic
•
Search
•
Log In
•
Print View
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:
Reply
•
Quote
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:
Reply
•
Quote
Go to:
Forum List
•
Message List
•
Search
•
Log In
Sorry, only registered users may post in this forum.
Click here to login