mysql strict mode code example

Example: 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