如何在MySQL中动态插入数据

Question

I need to record the date each event happens. I have this table.

Click here to view the table

NULL spaces are available to save a new date. The X represents the date that the event occurred.

The problem is I do not know how to update the date each event occurs

I need to know the best option if you use INSERT or UPDATE querys.

Thank you for your help

Answer 1

If you just want to update a column in a table with the current time:

UPDATE `yourtable` SET `yourcolumn` = NOW() WHERE `ID` = yourid

Assuming your columns are DATETIME() columns.

As an aside, it's best to have event-related information in another relationship table. This way you can link multiple events for each row in your main table. This provides a more accurate data-trail for accounting purposes (or in other words, you can see each and every update without overwriting anything).