Set the default time in MySQL to the current time of the system

Set the default time in MySQL to the current time of the system

• A scenario encountered when designing a database: Setting the system's current time to the default value store

• Database Design Code:

  CREATE TABLE `test` (  `name` varchar(50) NOT NULL,  `createtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;  

• If you use SQLyog to set the default value for a Time field, you need to set the Time field type to "timestamp", and then fill in the default value with "Current_timestamp".
  
  
  

Set the default time in MySQL to the current time of the system