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)