Next: Modifying Several Tuples At Up: No Title Previous: The Delete Command

The Update Command

U5: Change the location and controlling department number of project 10 to `Bellaire' and 5, respectively.

 
U5: 		 UPDATE  		 PROJECT

		 SET 		 PLOCATION=`Bellaire',DNUM=5

		 WHERE 		 PNUMBER=10

Larry Latour
Sun Oct 27 22:51:12 EST 1996