|
DELIMITER $$
|
CREATE OR REPLACE PROCEDURE p1()
|
BEGIN
|
SET GLOBAL max_allowed_packet=16000000, max_error_count=60;
|
SELECT @@GLOBAL.max_allowed_packet, @@GLOBAL.max_error_count;
|
END;
|
$$
|
DELIMITER ;
|
SHOW PROCEDURE CODE p1;
|
+-----+---------------------------------------------------+
|
| Pos | Instruction |
|
+-----+---------------------------------------------------+
|
| 0 | stmt 31 "SET GLOBAL max_allowed_packet=16000000" |
|
| 1 | stmt 31 "SET max_error_count=60" |
|
| 2 | stmt 0 "SELECT @@GLOBAL.max_allowed_packet, @..." |
|
+-----+---------------------------------------------------+
|
Notice, the second "stmt" instruction is missing the GLOBAL keyword.
|