With the help of CURDATE() and NOW() functions, we can automatically insert the current date into the columns of the MySQL table.
Suppose we want to automatically insert the current date in the OrderDate column of table year_testing, the following query will do this -
mysql> Insert into year_testing (OrderDate) Values(CURDATE()); Query OK, 1 row affected (0.11 sec) mysql> Select * from year_testing; +------------+ | OrderDate | +------------+ | 2017-10-28 | +------------+ 1 row in set (0.00 sec) mysql> Insert into year_testing (OrderDate) Values(NOW()); Query OK, 1 row affected, 1 warning (0.12 sec) mysql> Select * from year_testing; +------------+ | OrderDate | +------------+ | 2017-10-28 | | 2017-10-28 | +------------+ 2 rows in set (0.00 sec)
The above is the detailed content of How to automatically insert current date in column of MySQL table?. For more information, please follow other related articles on the PHP Chinese website!