自 ,现在可以使用DATETIME字段实现此目的,请看下面的另一篇文章 …
以前的版本无法在DATETIME做到这一点…
但是您可以使用TIMESTAMP来做到这一点:
MysqL> create table test (str varchar(32), ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP);
Query OK, 0 rows affected (0.00 sec)
MysqL> desc test;
+-------+-------------+------+-----+-------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+-------------------+-------+
| str | varchar(32) | YES | | NULL | |
| ts | timestamp | NO | | CURRENT_TIMESTAMP | |
+-------+-------------+------+-----+-------------------+-------+
2 rows in set (0.00 sec)
MysqL> insert into test (str) values ("demo");
Query OK, 1 row affected (0.00 sec)
MysqL> select * from test;
+------+---------------------+
| str | ts |
+------+---------------------+
| demo | 2008-10-03 22:59:52 |
+------+---------------------+
1 row in set (0.00 sec)
MysqL>