开发者

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

开发者 https://www.devze.com 2022-12-28 00:04 出处:网络
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 \'ListingKe

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

0

精彩评论

暂无评论...
验证码 换一张
取 消