Create procedure and setup sql mode in MYSQL

DELIMITER $$
--
-- Procedure
--
CREATE DEFINER=`r3`@`localhost` PROCEDURE `runSQLmode`()
    NO SQL
BEGIN

SET GLOBAL sql_mode ='NO_ENGINE_SUBSTITUTION';
SET SESSION sql_mode ='NO_ENGINE_SUBSTITUTION';

END$$

DELIMITER ;

發表迴響