Difference between revisions of "Column types"
From MyWiki
| Line 8: | Line 8: | ||
) | ) | ||
</source> | </source> | ||
| − | |||
<source lang="text"> | <source lang="text"> | ||
mysql> create table tape_usage ( when_at datetime , inuse int ); | mysql> create table tape_usage ( when_at datetime , inuse int ); | ||
Latest revision as of 14:49, 25 September 2014
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)
