mysql复习增删改查

 

select * from torder where status='退款申请'
UPDATE torder SET `status`='退款申请' WHERE status='等待付款' and id="";
DELETE FROM torder WHERE `status`='123456'
INSERT into torder(lid,seat) VALUES('66','66')