I should know how to find column cost change
example:
Table name = test
abc 12a 32 sdf 23s df fds
If I can find the row which is c column "fds" .
Question:
Choose from exam * where C = 'FDA';
But at the same time, I have to see whether all field values change or not.
Thanks in advance
Not sure that I fully understand What do you want to do, but when you add the last column you can get the last change. Either you update the table manually or, on each update query, you can set the CURRENT_TIMESTAMP
to be the default value of the column and an update CURRENT_TIMESTAMP
The clause can add the track of the latest updates.
Comments
Post a Comment