Difference between revisions of "Column types"
From MyWiki
| 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 | + | OrderDate datetime NOT NULL DEFAULT curdate(), |
PRIMARY KEY (OrderId) | PRIMARY KEY (OrderId) | ||
) | ) | ||
</source> | </source> | ||
Revision as of 14:41, 25 September 2014
CREATE TABLE Orders ( OrderId INT NOT NULL, ProductName VARCHAR(50) NOT NULL, OrderDate datetime NOT NULL DEFAULT curdate(), PRIMARY KEY (OrderId) )
