php - mysql : check the content change or not -


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