Code:
mysql> show triggers; Empty set (0.01 sec) mysql> SHOW PROCEDURE STATUS; +-----------+--------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | Db | Name | Type | Definer | Modified | Created | Security_type | Comment | character_set_client | collation_connection | Database Collation | +-----------+--------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ | edomiLive | mqtt_publish | PROCEDURE | root@localhost | 2018-08-23 22:13:19 | 2018-08-23 22:13:19 | DEFINER | | latin1 | latin1_swedish_ci | latin1_swedish_ci | +-----------+--------------+-----------+----------------+---------------------+---------------------+---------------+---------+----------------------+----------------------+--------------------+ 1 row in set (0.01 sec) mysql>
Kommentar