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?

It's annoying that it doesn't have another tab "triggers" – Francisco Presencia Dec 19 '13 at 00:38 — Francisco Presencia, Dec 19 '13 at 00:38
phpMyAdmin is a tool, not a database – RiggsFolly May 10 '17 at 20:28 — RiggsFolly, May 10 '17 at 20:28

score 28 · Accepted Answer · answered Mar 24 '11 at 14:37

28

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

SHOW TRIGGERS

answered Mar 24 '11 at 14:37

Eugene Yarmash

2

You can use mysqldump with --triggers switch http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html – Nicola Cossu Mar 24 '11 at 14:41
1

Or you can use Database Backup or Gen.Schema Script in dbForge Studio for MySQL. – Devart Mar 24 '11 at 15:00
1

mysqldump backs up triggers by default: "--triggers Include triggers for each dumped table in the output. This option is enabled by default;" – sdjuan Jan 19 '13 at 00:04

score 5 · Answer 2 · answered Mar 24 '11 at 14:38

5

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

answered Mar 24 '11 at 14:38

Nicola Cossu

3

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. – dionyziz Feb 26 '12 at 17:31
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. – daker Nov 13 '14 at 08:16

score 1 · Answer 3 · edited Feb 04 '13 at 10:10

1

to see all your routines the code is...

select * from information_schema.routines

edited Feb 04 '13 at 10:10

swapnesh

answered Feb 04 '13 at 09:54

Silvio Troia

3 Answers3