SET SQL_MODE = ''; does not work

#1 (**permalink**) 02-28-2008, 09:50 AM

Hello,

I have a problem with the configuration of a database.
It is set to SQL_MODE =
'STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE _SUBSTITUTION'
and I can not save 'empty' dates.

After searching the manual, I found something about SQL_MODE and
wanted to set it, but it does not work. Not even for the Session.

What I do:

select @@sql_mode;
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_ SUBSTITUTION
SET SQL_MODE = '';
(no result, "Abgabe erzeugte keine Ergebnismenge")
select @@sql_mode; is still the same as before.

I am logged in as root. Any suggestion?

Best regards
Ralph

#2 (**permalink**) 02-28-2008, 09:50 AM

Does SET @@SQL_MODE = '' work?

--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/

#3 (**permalink**) 02-28-2008, 09:50 AM

On Tue, 15 May 2007 15:02:18 +0200, Willem Bogaerts
<w.bogaerts@kratz.maardanzonderditstuk.nl> wrote:

>Does SET @@SQL_MODE = '' work?

Don't you have to stop and restart MySQL (service) for these types of
changes to take effect?

Lee

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode