4 default update

delete --- 删除数据(删除行)

delete from clown_info
where
activities='dancing';

update----- 改变数据
更新一列或多列的值
update doughnut_ratings
set
type='glazed'
where type ='plain glazed';

set 告诉 RDBMS ,它要把 where子句提到的原始列值改为它
这一句中的值。

update table_name
set column_name =newvalue
where column_name = somevalue;

update clown_info
set last_seen='Tracy'
where name='hobo'
and last_seen='park';