i want to know what is the best way to keep the original record in MySQL database, when some one request to update an existing record or want to delete a record.
how i can keep the record of the original entry made by a user.
Instead of updating the existing record, insert a new record. For this to work, you need to include a timestamp field that gets set to NOW(), and when selecting the current information you grab only the latest record.
SELECT * FROM table_name WHERE user_id = 123 ORDER BY timestamp_column DESC LIMIT 1
"Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
~ Terry Pratchett in Nation
How to Ask Questions the Smart Way
(not affiliated with this site, but well worth reading)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)