directman

SQLExec ("set global sql_mode='';");

print_r ( sqlselect("SHOW VARIABLES LIKE 'sql_mode';"));

Array
(
    [Variable_name] => sql_mode
    [Value] => IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
)

SQLExec ("set global sql_mode='STRICT_TRANS_TABLES';");

print_r ( sqlselect("SHOW VARIABLES LIKE 'sql_mode';"));

Array
(
    [Variable_name] => sql_mode
    [Value] =>  STRICT_TRANS_TABLES,IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
)

...

Смотрите так же: