How to store the history of field values ​​in a database?

Question

MySQL

Hello. One question arose here, but I'm not strong in the database. Who can help?
There is a table of SHOP stores, which is also used in complex queries.
It is necessary to store the history of names (for change, deletion). How would you do it the right way?
Shop (
id int autoincrement primary key,
name string,
addr string,
shedule string,
type int key
)

Answer 1

https://toster.ru/answer?answer_id=1059951