How can I find all the db triggers in MySQL?

Question

I created a trigger using SQL, how can I see the trigger using MySQL in phpMyadmin?

Solution 1

Click on the 'SQL' tab and enter this query:

SHOW TRIGGERS

Solution 2

select * from information_schema.triggers where trigger_schema = 'your_db'

Solution 3

to see all your routines the code is...

select * from information_schema.routines

Comments

[Nicola Cossu]

You can use mysqldump with --triggers switch dev.mysql.com/doc/refman/5.0/en/mysqldump.html

[Devart]

Or you can use Database Backup or Gen.Schema Script in dbForge Studio for MySQL.

[dionyziz]

There are commands to manage a database schema other than interacting directly with the information_schema database such as SHOW TRIGGERS which should be preferred.

[sdjuan]

mysqldump backs up triggers by default: "--triggers Include triggers for each dumped table in the output. This option is enabled by default;"

[daker]

Is this the best way if you want to create a view of your triggers? SHOW TRIGGERS is not valid in "AS" for create view.