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
精彩评论