mode

How to enable mysql 5 compatibility mode

Submitted by CoolGoose on Fri, 12/05/2008 - 02:08

Posted in

You can retrieve the current global or session sql_mode value with the following statements:

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

And set it with :

Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"
Start MySQL with the option --sql-mode="MYSQL40"
Execute the query SET GLOBAL sql_mode='MYSQL40'

Add new comment

If you need more help on the topic feel free to add a comment or create a new post on the Forum