Skip to main content

sql

How to enable mysql 5 compatibility mode

In:
4Dec2008

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

  1. SELECT @@GLOBAL.sql_mode;
  2. SELECT @@SESSION.sql_mode;

And set it with :

  1. REPLACE IN my.ini the current sql-mode line WITH sql-mode="MYSQL40"
  2. Start MySQL WITH the OPTION --sql-mode="MYSQL40"
  3. Execute the query SET GLOBAL sql_mode='MYSQL40'

Drupal port by 3rdWorld : Created by Design Disease