1. Home
2. php - How can I keep record of changes after an update in a table in mysql?

698 votes

1 answers

php - How can I keep record of changes after an update in a table in mysql?

Get the solution ↓↓↓

Im importing a csv file into a sql table, from there it is ok. Im also updating a column called date, so everytime an user import a file it also updates the date. But the problem is that the user needs to upload a file every month and I need to keep track of every upload into the table. I do not know how to do it. Can somebody give me a hint?

Undefined asked

2021-11-30

Write your answer

---

537

votes

Answer

Solution:

If you don't need to know changes in the file you can just use a column with an update date (you can use triggers for this or edit your column like: `tm` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP). You could also store a number of "edit times" to see if it's the same as the number of months since the creation of the row. Otherwise, you should write a new row for every update and keep track of the user by an ID.

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-11-30

Link To Source
Link To Answer People are also looking for solutions of the problem: xml parsing error: no root element found

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

513 php - Use mysql_fetch_array() with foreach() instead of while()

632 PHP/MySQL - any shorthand equivalent for PDO UPDATE?

593 jquery - execute php/javascript function after a certain amount of time has passed

477 php - Check if a variable has been set with the name of the value of another variable

64 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

492 php - Using JQuery UI's sortable('serialize') after loading data in via .load();

744 php - Save data to two different tables in CakePHP 3

544 php - Cakephp 2.8.4 ignoring hasMany

571 php - Filter content from mysql db with checkboxes using jQuery?

29 php - Nested mysql_query() - Resets first result's pointer?

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/