According to the MySQL documentation, stored procedures are executed with the sql_mode
in which they were created.
I need to change the sql_mode parameter for a specific stored procedure
SHOW CREATE PROCEDURE
command - shows the current sql_mode
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
How can it be changed, specifically - remove strict mode
Thanks
SHOW CREATE PROCEDURE
.
.sql
file on-disk for safe-keeping and ensure it matches the procedure in your project's source-control (git, SVN, TFS, etc).
DROP PROCEDURE
.sql_mode
is set correctly.CREATE PROCEDURE
with the .sql
file you saved in step 1.