I have built an e-commerce website where the admin can edit the products through MySQL. Now I want to display the edit history of each product. The edit history should contain the 'date when it was updated' and 'what was updated'.

**This is my product table**: [![Click here to see the table](https://i.stack.imgur.com/Sbugh.png)](https://i.stack.imgur.com/Sbugh.png)

I thought of creating new columns "Edit history" and "Edit Date" inside the product table. Whenever the admin would edit one column, it would get added here.

If anyone knows how to proceed with either this method or some alternative method to solve this issue, please let me know.