Strict Mode In Mysql

Source URL: https://stackoverflow.com/questions/40881773/how-to-turn-on-off-mysql-strict-mode-in-localhost-xampp

Language: sql

Created on: 2021-05-09 06:47:41

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
I want to know how to check whether MySQL strict mode is on or off in localhost(xampp). If on then for what modes and how to off. If off then how to on. I already followed http://dev.mysql.com/doc/
content_copy