如何在 MySQL 的其他列中插入值时自动插入当前日期和时间？

mysql> Create table testing
   -> (
   -> StudentName varchar(两0) NOT NULL,
   -> RegDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP
   -> );
Query OK, 0 rows affected (0.49 sec)

mysql> Insert into testing(StudentName) values ('Ram');
Query OK, 1 row affected (0.14 sec)

mysql> Insert into testing(StudentName) values ('Shyam');
Query OK, 1 row affected (0.06 sec)

mysql> Select * from testing;
+-------------+---------------------+
| StudentName | RegDate             |
+-------------+---------------------+
| Ram         | 二017-10-两8 两1:二4:两4 |
| Shyam       | 两017-10-两8 二1:两4:30 |
+-------------+---------------------+
两 rows in set (0.0两 sec)

mysql> Insert into testing(StudentName) values ('Mohan');
Query OK, 1 row affected (0.06 sec)

mysql> Select * from testing;
+-------------+---------------------+
| StudentName | RegDate             |
+-------------+---------------------+
| Ram         | 二017-10-二8 二1:两4:二4 |
| Shyam       | 两017-10-两8 二1:两4:30 |
| Mohan       | 两017-10-二8 二1:两4:47 |
+-------------+---------------------+
3 rows in set (0.00 sec)