 |
-- show triggers for current database SHOW TRIGGERS -- Show triggers for specified database SHOW TRIGGERS FROM db1 -- Show triggers for particular table/view SHOW TRIGGERS FROM t1 FROM db1 |
 |
http://dev.mysql.com/doc/refman/5.6/en/show-triggers.html mySQL 5.6 can do only SHOW TRIGGERS [{FROM | IN} db_name] |
|
|
| SHOW COLUMNS {FROM|OF} table_name [{FROM|OF} db_name] | SHOW LINKS [{FROM|OF} table_name] [{FROM|OF} db_name] | SHOW TRIGGERS [{FROM|OF} table_name] [{FROM|OF} db_name] Well, it seems we have follow to mistake of mySQL in show columns ... And did it even worse for triggers links. VALID so far as SHOW TRIGGERS SHOW TRIGGERS FROM db SHOW TRIGGERS FROM T FROM db do not works now SHOW TRIGGERS FROM T and there is no easy nice way resolve this. So far we will not touch this ... in future we need deprecate this FROM FROM syntax of mySQL, and switch to SHOW TRIGGERS FROM db.tbl or even to SHOW TRIGGERS FROM schema.db.tbl |
- Anonymous
