How can I insert row in table when one field is get updated?

I have requirement like, suppose I have a 'pro开发者_如何学编程perty' table which has 'ListingKey' field and I want to do entry in another table say 'property_history' table whenever 'ListingKey' field is update. How it is possible with mysql ? should I use trigger then how can I use it?

Please Help me,

Thanks, :Jimit

By using trigger you can easily achieve this

following is link for the my sql trigger creation

http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html