mysql datetime默认_如何设置MySQL Datetime列的默认值？

How do you set a default value for a MySQL Datetime column?

In SQL Server it's getdate(). What is the equivalant for MySQL? I'm using MySQL 5.x if that is a factor.

解决方案

IMPORTANT EDIT:

It is now possible to achieve this with DATETIME fields since MySQL 5.6.5, take a look at the other post below...

Previous versions can't do that with DATETIME...

But you can do it with 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>