#902 (ok 2.11) Trigger

fixed
None
1
2013-06-11
2006-03-20
No

It would be nice if all the triggers exists for a
table would be shown on tbl_properties_structure.php.

Thanks
Andreas

P.S. I know nothing about php. So the query is not
quotet. This is only for demonstrate my idea.

Discussion

  • Anonymous

    Anonymous - 2006-04-12

    Logged In: YES
    user_id=509287

    even more important IMHO would be to output the triggers in
    SQL-Exports!
    Actually showing the triggers isn't hard, as they can easily
    be found in the information_schema database if it is queried
    by the real user (not the pma-user).
    What i am also missing: in the mask to grant users
    privileges there is no 'CREATE TRIGGER' privilege which
    should be available in MySQL 5. (At least it is mentioned in
    the 'New Feature Series'-Tutorial)

     
  • Andreas Sakowski

    Logged In: YES
    user_id=849426

    i have a new idea for triggers. see the attached files.

     
  • Marc Delisle

    Marc Delisle - 2007-06-29
    • priority: 5 --> 1
    • assigned_to: nobody --> lem9
    • summary: Trigger --> (ok 2.11) Trigger
    • status: open --> open-accepted
     
  • Marc Delisle

    Marc Delisle - 2007-06-29

    Logged In: YES
    user_id=210714
    Originator: NO

    Done for 2.11-dev. Please try the latest snapshot of "trunk" from http://www.phpmyadmin.net/snapshot and post your comments here.

     
  • Marc Delisle

    Marc Delisle - 2007-08-21
    • status: open-accepted --> closed-accepted
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-accepted --> fixed