Table creation: Difference between revisions
Content added Content deleted
No edit summary |
|||
Line 16: | Line 16: | ||
CREATE TABLE `Address` ( |
CREATE TABLE `Address` ( |
||
`addrID` int(11) NOT NULL auto_increment, |
`addrID` int(11) NOT NULL auto_increment, |
||
`addrStreet` varchar(50) NOT NULL default '', |
`addrStreet` varchar(50) NOT NULL default '', |
||
`addrCity` varchar(25) NOT NULL default '', |
`addrCity` varchar(25) NOT NULL default '', |
||
`addrState` char(2) NOT NULL default '', |
`addrState` char(2) NOT NULL default '', |
||
`addrZIP` char(10) NOT NULL default '', |
`addrZIP` char(10) NOT NULL default '', |
||
PRIMARY KEY |
PRIMARY KEY (`addrID`) |
||
); |
); |
Revision as of 14:00, 23 January 2007
Table creation
You are encouraged to solve this task according to the task description, using any language you may know.
You are encouraged to solve this task according to the task description, using any language you may know.
In this task, the goal is to create a table to store addresses.
UDB DB2
CREATE TABLE Address ( addrID Integer generated by default as identity, addrStreet Varchar(50) not null, addrCity Varchar(25) not null, addrState Char(2) not null, addrZIP Char(10) not null )
MySQL
CREATE TABLE `Address` ( `addrID` int(11) NOT NULL auto_increment, `addrStreet` varchar(50) NOT NULL default , `addrCity` varchar(25) NOT NULL default , `addrState` char(2) NOT NULL default , `addrZIP` char(10) NOT NULL default , PRIMARY KEY (`addrID`) );