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