Subject | On Updating One Column Value, Update Time Stamp in Another Column |
---|---|
Author | Vishal Tiwari |
Post date | 2017-08-09T08:50:52Z |
Hi All,
I have one issue to share with you.
I have one table say "MyTable", which has five columns, say Col1, Col2,...,Col5 and it has 10 rows. Col5 is of Timestamp.
My issue is, whenever I am updating Col3, that time, only for that row of Col5, Timestamp value should be updated to the current timestamp.
What would be the best option for this?
If trigger is the best way then how would I do it? As I never worked on Triggers.
Kindly let me know if my issue is not clear.
Thanks In Advance.
With Best Regards.
Vishal