Search for question
Question

10. Another practical use of trigger is to maintain a history of values as they change. Create a table named post_content_history that is used to record updates to the content

of a post, then create a trigger that keeps this table up-to-date when updates happen to post contents. Verify the trigger works by updating a post's content, then listing out the post_content_history table (which should have a record of the update).

Fig: 1