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‘)
mysql复习增删改查
原文:http://www.cnblogs.com/zzzzw/p/4836105.html