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')
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')
转载于:https://www.cnblogs.com/zzzzw/p/4836105.html