How to Edit Trigger in phpmyadmin in XAMPP?

Question

I can't find out how to view the TRIGGER in XAMPP phpmyadmin? can somebody help me with this? where I can find the trigger code in phpmyadmin?

thanks.

https://wiki.phpmyadmin.net/pma/Trigger – woofmeow Aug 15 '13 at 06:54 — woofmeow, Aug 15 '13 at 06:54

score 2 · Answer 1 · answered Aug 15 '13 at 08:35

2

You can edit trigers on Triggers tab in database. For example see demo server.

answered Aug 15 '13 at 08:35

Michal Čihař

score 0 · Answer 2 · answered Apr 11 '18 at 15:08

0

If you want to display existing TRIGGERS (without editing them), you can enter one of the following commands in phpMyAdmin's SQL tab:

`SHOW TRIGGERS`

or

SELECT * from information_schema.triggers WHERE trigger_schema = 'your_db'

answered Apr 11 '18 at 15:08

OuzoPower

Note that the answer the original post by ChocoMartin is a duplicate of [link](https://stackoverflow.com/questions/5420812/how-can-i-find-all-the-db-trigger-in-mysql) where these answers were already provided. Unfortunately, I could not comment the original message. – OuzoPower Apr 11 '18 at 15:10

2 Answers2