Basic HTML version of Foils prepared 7 October 97

Foil 20 DML Examples - II

From untitled presentation ARL Database Tutorial -- February 98. by Gang Cheng, C.W. Ou, Geoffrey C. Fox
This statement updates a column of a particular row
  • UPDATE person_info_table SET first_name = 'frank' WHERE user_name = 'thlin';
This statement deletes a row from a table
  • DELETE FROM person_info_table WHERE user_name = 'thlin';

© 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