Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

You can include the NULL attribute in the definition of a TIMESTAMP column to allow the column to contain NULL values For examp

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)