Anonymous user
Table creation/Postal addresses: Difference between revisions
m
Alphabetized
m (→{{header|MySQL: Oops. Missed.) |
m (Alphabetized) |
||
Line 2:
In this task, the goal is to create a table to store addresses.
=={{header|DB2 UDB}}==▼
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▼
)▼
=={{header|MySQL}}==
Line 52 ⟶ 61:
STOP;
RUN;
▲=={{header|DB2 UDB}}==
▲ 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
▲ )
| |||