Update

Update is a SQL DML command used to change data in a table. Note that it's important to specify a WHERE-clause, if not ALL rows in the table will be updated.

Examples

Give employees in department 10 an 10% raise:

UPDATE emp SET sal = sal*1.1 WHERE deptno = 10;

Give employee number 7844 a $100 commission:

UPDATE emp SET comm = 100 WHERE empno = 7844;

Also see

• Select
• Insert
• Delete

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#