"MySQL" Automatically records creation date and update date

There is usually a field in the table where create date is created, and other databases have the option of default values. MySQL also has a default value of timestamp, but in MySQL, not only is the insertion to be modified will also update the value of Timestamp!

So to record the creation date in MySQL you have to use datetime and then use the now () function to complete!

1,timestamp DEFAULT current_timestamp on UPDATE current_timestamp  
Refreshes the data column when creating new records and modifying existing records

2,timestamp DEFAULT current_timestamp  

This field is set to the current time when a new record is created, but it is not refreshed when you modify it later

3,timestamp on UPDATE current_timestamp set this field to 0 when creating a new record

"MySQL" Automatically records creation date and update date