刪除全部訂單： delete FROM `ecs_order_info`

刪除未確認(rèn)訂單：delete FROM `ecs_order_info` where  order_status ='0'

刪除已取消訂單：delete FROM `ecs_order_info` where  order_status ='2'

刪除已確認(rèn)訂單：delete FROM `ecs_order_info` where  order_status ='1'

需要注意的是 ecs_order_info 里的 ecs_ 要換成你的數(shù)據(jù)表前綴!