PHP - Moved: Some Easy Questions Regarding Phpmyadmin And Php?

I have a table leitner_vcard_boxes. Each row represents a flashcard. I want to be able to efficiently sort the cards by the frequency with which the user got them correct.  Each row has a column right_count and wrong_count and a percent_correct which I calculate in php as right_count/(right_count+wrong_count) I want to replace the manual calculation with a trigger since I believe that would be more efficient than reading the row, incrementing the right or wrong counter, calculating the new percentage correct and updating the row. The trigger I plan to use is:

CREATE TRIGGER upd_right_percent AFTER UPDATE ON leitner_vcard_boxes
FOR EACH ROW
BEGIN

    UPDATE leitner_vcard_boxes SET right_percent=right_count/(right_count+wrong_count);

END;

My questions a 1. Is the trigger going to give me the desired outcome? 2. If I export the leitner_vcard_boxes table from my development server's phpMyAdmin and replace (import) the table on the test server will the trigger move with it? Do I need to move the trigger separately? 3. How do I list the triggers in the database? Can I see them in phpMyAdmin someplace and I am just missing it? 4. What else should somebody who has not used triggers before consider?  

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=355485.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=359282.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=355885.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=314698.0