[MySQL] DATETIME DEFAULT NOW() doesn't work. > db

MySQL에서 DATETIME DEFAULT NOW()는 동작하지 않는다.

시도하면 다음과 같은 에러에 직면한다.

mysql> CREATE TABLE tb_word (
    -> word_id INT AUTO_INCREMENT,
    -> create_time DATETIME DEFAULT NOW(),
    -> PRIMARY KEY (word_id)
    -> );
ERROR 1067 (42000): Invalid default value for 'create_time'
mysql>

다음과 같이 TIMESTAMP 타입에 대해서는 동작한다.

mysql> CREATE TABLE tb_word (
    -> word_id INT AUTO_INCREMENT,
    -> create_time TIMESTAMP DEFAULT Now(),
    -> PRIMARY KEY (word_id)
    -> );
Query OK, 0 rows affected (0.35 sec)

mysql> INSERT INTO tb_word VALUES ();
Query OK, 1 row affected (0.11 sec)

mysql> SELECT * FROM tb_word;
+---------+---------------------+
| word_id | create_time         |
+---------+---------------------+
|       1 | 2011-04-04 00:10:10 |
+---------+---------------------+
1 row in set (0.09 sec)

mysql>

Reference:
http://niflheim.tistory.com/tag/mysql%20default%20now%28%29