mysql>mysql> CREATE TABLE myTable -> ( -> ts1 TIMESTAMP NULL DEFAULT NULL, -> ts2 TIMESTAMP NULL DEFAULT 0, -> ts3 TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP -> );Query OK, 0 rows affected (0.01 sec)mysql>mysql> desc myTable;+-------+-----------+------+-----+---------------------+-------+| Field | Type | Null | Key | Default | Extra |+-------+-----------+------+-----+---------------------+-------+| ts1 | timestamp | YES | | NULL | || ts2 | timestamp | YES | | 0000-00-00 00:00:00 | || ts3 | timestamp | YES | | CURRENT_TIMESTAMP | |+-------+-----------+------+-----+---------------------+-------+3 rows in set (0.02 sec)mysql>mysql> drop table myTable;Query OK, 0 rows affected (0.00 sec)
Name (required)
email (will not be published) (required)
Website