home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 10 Tools
/
10-Tools.zip
/
ool.zip
/
OOL
/
samples
/
sample10
/
sample10.sql
< prev
next >
Wrap
Text File
|
1996-11-30
|
438b
|
19 lines
CREATE TABLE ADRESS
(
ID INTEGER NOT NULL,
NAME VARCHAR(30) NOT NULL,
STREET VARCHAR(40),
ZIPCODE VARCHAR(10),
CITY VARCHAR(40),
PHONE VARCHAR(30),
BIRTHDAY DATE,
PRIMARY KEY(ID)
)
INSERT INTO ADRESS VALUES( 1, 'Miller', 'Main Avn.', '', 'New York', '', '10.12.1960')
INSERT INTO ADRESS VALUES( 2, 'Baker', '', '', 'Los Angeles', '', '27.03.1964')
INSERT INTO ADRESS VALUES( 3, 'Baker', '', '', 'Denver', '', NULL)