Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
How to enable MySQL 5 strict
Posted by: Logan (---.pppoe-dynamic.nb.aliant.net)
Date: August 08, 2006 01:56PM

Hello,
I'd like to know how to enable MySQL 5 strict mode. Strict mode should be enabled by default, but it currently is not.

I've heard of running this command: SET @@global.sql_mode='STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'

would work... but there is no where to run it in mysql administrator?

Thanks.

Options: Reply•Quote
Re: How to enable MySQL 5 strict
Posted by: yfastud (72.236.169.---)
Date: August 08, 2006 02:12PM

Did you try it in phpMyAdmin?

Options: Reply•Quote
Re: How to enable MySQL 5 strict
Posted by: Logan (---.pppoe-dynamic.nb.aliant.net)
Date: August 08, 2006 03:03PM

No, I didn't think it is possible in phpMyAdmin. It's for managing the databases not the MySQL server settings.

But if you have an idea let me know.



Post Edited (08-08-06 15:31)

Options: Reply•Quote
Re: How to enable MySQL 5 strict
Posted by: dval (---.chrcitadelle.be)
Date: August 08, 2006 03:36PM

look at this page :
[dev.mysql.com]

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