Table creation: Difference between revisions
Content added Content deleted
No edit summary |
|||
Line 22: | Line 22: | ||
`addrZIP` char(10) NOT NULL default '', |
`addrZIP` char(10) NOT NULL default '', |
||
PRIMARY KEY (`addrID`) |
PRIMARY KEY (`addrID`) |
||
); |
|||
==[[PostgreSQL]]== |
|||
CREATE SEQUENCE address_seq start 100; |
|||
CREATE TABLE address ( |
|||
addrID int4 PRIMARY KEY DEFAULT nextval('address_seq'), |
|||
street varchar(50) not null, |
|||
city varchar(25) not null, |
|||
state varchar(2) not null, |
|||
zip varchar(20) not null |
|||
); |
); |
Revision as of 14:33, 23 January 2007
![Task](http://static.miraheze.org/rosettacodewiki/thumb/b/ba/Rcode-button-task-crushed.png/64px-Rcode-button-task-crushed.png)
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`) );
PostgreSQL
CREATE SEQUENCE address_seq start 100; CREATE TABLE address ( addrID int4 PRIMARY KEY DEFAULT nextval('address_seq'), street varchar(50) not null, city varchar(25) not null, state varchar(2) not null, zip varchar(20) not null );