Difference between revisions of "Column types"
From MyWiki
(Created page with "<source lang="sql"> CREATE TABLE Orders ( OrderId int NOT NULL, ProductName varchar(50) NOT NULL, OrderDate datetime NOT NULL DEFAULT NOW(), PRIMARY KEY (OrderId) ) </source>") |
|||
| Line 4: | Line 4: | ||
OrderId int NOT NULL, | OrderId int NOT NULL, | ||
ProductName varchar(50) NOT NULL, | ProductName varchar(50) NOT NULL, | ||
| − | OrderDate datetime NOT NULL DEFAULT NOW(), | + | OrderDate datetime NOT NULL DEFAULT NOW(),//( rubbish ) |
PRIMARY KEY (OrderId) | PRIMARY KEY (OrderId) | ||
) | ) | ||
</source> | </source> | ||
Revision as of 14:40, 25 September 2014
CREATE TABLE Orders ( OrderId INT NOT NULL, ProductName VARCHAR(50) NOT NULL, OrderDate datetime NOT NULL DEFAULT NOW(),//( rubbish ) PRIMARY KEY (OrderId) )
