Column types
From MyWiki
CREATE TABLE Orders ( OrderId INT NOT NULL, ProductName VARCHAR(50) NOT NULL, OrderDate datetime , PRIMARY KEY (OrderId) )
mysql> create table tape_usage ( when_at datetime , inuse int ); Query OK, 0 rows affected (0.61 sec) mysql> desc tape_usage; +---------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------+------+-----+---------+-------+ | when_at | datetime | YES | | NULL | | | inuse | int(11) | YES | | NULL | | +---------+----------+------+-----+---------+-------+ 2 rows in set (0.15 sec)