CODEWITHSUNDEEP
mysqldatabasephpmyadmindatabase-trigger
Tattat
Tattat

Reputation: 15778

How can I find all the db triggers in MySQL?

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

Upvotes: 14

Views: 28347

Answers (3)

Silvio Troia
Silvio Troia

Reputation: 1459

to see all your routines the code is...

select * from information_schema.routines

Upvotes: 1

Nicola Cossu
Nicola Cossu

Reputation: 56397

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

Upvotes: 5

Eugene Yarmash
Eugene Yarmash

Reputation: 149971

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

SHOW TRIGGERS

Upvotes: 29

Related Questions