十二.更新和删除数据
- 更新数据
三步:
确定要更新的表
列名和它的新值
确定过滤条件
update customers
set cust_email = 'kim@thetoystore.com',
cust_contact = 'Sam Roberts'
where cust_id = '1000000005';
- 删除数据
从表中删除特定行
delete from cuatomers
where cust_id = 100000006';
十二.更新和删除数据
update customers
set cust_email = 'kim@thetoystore.com',
cust_contact = 'Sam Roberts'
where cust_id = '1000000005';
delete from cuatomers
where cust_id = 100000006';