今日成果：
update invoices
set payment_total = invoice_total *0.5,payment_date = due_date
where invoice_id = 1;
-- 更新单行记录
update orders
set comments = '金牌顾客'
where customer_id in (select customer_id from customers where points > 3000);
-- 更新多条记录
delete from invoices
where invoice_id = 1;
-- 删除某条记录感谢各位读者查阅，欢迎各位👍点赞✍评论⭐收藏+关注！
![盛最多水的容器[中等]](https://img-blog.csdnimg.cn/direct/4587aeff650543f3a2fece74ad0f9f7b.png)
