1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE DATABASE test1;
CREATE PROCEDURE test1.sp3() BEGIN END;
SHOW PROCEDURE STATUS WHERE Db <> 'sys';
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
mtr add_suppression PROCEDURE root@localhost # # DEFINER utf8mb3 utf8mb3_general_ci utf8mb4_uca1400_ai_ci
mtr check_testcase PROCEDURE root@localhost # # DEFINER utf8mb3 utf8mb3_general_ci utf8mb4_uca1400_ai_ci
mtr check_warnings PROCEDURE root@localhost # # DEFINER utf8mb3 utf8mb3_general_ci utf8mb4_uca1400_ai_ci
mysql AddGeometryColumn PROCEDURE mariadb.sys@localhost # # INVOKER latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
mysql DropGeometryColumn PROCEDURE mariadb.sys@localhost # # INVOKER latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
test sp2 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
test1 sp1 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
test1 sp3 PROCEDURE root@localhost # # DEFINER latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
DROP PROCEDURE sp2;
DROP DATABASE test1;
select count(*) from mysql.event;
count(*)
416
flush tables;
show events;
truncate table mysql.event;
|
