Answers for "mysql turn off strict mode"


strict mode in mysql

SHOW VARIABLES LIKE 'sql_mode';		-- enabled if STRICT_TRANS_TABLES is present
SET GLOBAL sql_mode='';							-- disables strict mode
SET GLOBAL sql_mode='STRICT_TRANS_TABLES';		-- enables strict mode
Posted by: Guest on May-09-2021

how to disable strict mode in mysql

->STRICT_TRANS_TABLES is responsible for setting MySQL strict mode.

->To check whether strict mode is enabled or not run the below sql:

If one of the value is STRICT_TRANS_TABLES, then strict mode is enabled, else not. In my case it gave

|Variable_name |Value                                     |
Hence strict mode is enabled in my case as one of the value is STRICT_TRANS_TABLES.

->To disable strict mode run the below sql:

set global sql_mode='';
[or any mode except STRICT_TRANS_TABLES. Ex: set global sql_mode='NO_ENGINE_SUBSTITUTION';]

->To again enable strict mode run the below sql:

set global sql_mode='STRICT_TRANS_TABLES';
Posted by: Guest on March-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language