如何在phpmyadmin和MySQL中创建插入和更新列？ [关闭]

Question

I need to have one table column that is going to record time and date when row has been inserted, and one when it was updated.

What is a best way to achieve this, and that is compatible with MySQL 5.5, 5.6, 5.7 versions ?

Also, how I can set everything in phpmyadmin ? Do I have to chose date or date and time -> timestamp as a column type ? And then what ?

I couldn't find any tutorial about this.

Answer 1

Your database should have timestamp column to record last update timestamp and DATETIME column to insert the date record was inserted.

CREATE TABLE `table` (
  `record_inserted` DATETIME, 
  `last_updated` TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP,
)
ENGINE = InnoDB;