Basic HTML version of Foils prepared
7 October 97
Foil 19 DML Examples - I
From
untitled presentation ARL Database Tutorial --
February 98
.
by
Gang Cheng, C.W. Ou, Geoffrey C. Fox
1
This statement selects all columns of a row whose last_name field value equals to 'Fox':
SELECT * FROM person_info_table WHERE last_name = 'Fox';
2
This statement inserts a row into the person_info_table table
INSERT INTO person_info_table (person_id, last_name, first_name, title, user_name, address) VALUES (99, 'lin', 'tseng-hui', 'gra', 'thlin', '3-211');
in Table To:
©
Northeast Parallel Architectures Center, Syracuse University, npac@npac.syr.edu
If you have any comments about this server, send e-mail to
webmaster@npac.syr.edu
.
Page produced by
wwwfoil
on Thu Feb 5 1998