# 清空数据
> 清空数据
```
<pre class="calibre6">```
<span class="token4">-- 订单相关</span>
<span class="token6">truncate</span> ims_ewei_shop_order<span class="token1">;</span> <span class="token4"># 订单表</span>
<span class="token6">truncate</span> ims_ewei_shop_order_buysend<span class="token1">;</span>
<span class="token6">truncate</span> ims_ewei_shop_order_comment<span class="token1">;</span>
<span class="token6">truncate</span> ims_ewei_shop_order_goods<span class="token1">;</span> <span class="token4"># 订单商品表</span>
<span class="token6">truncate</span> ims_ewei_shop_order_peerpay<span class="token1">;</span>
<span class="token6">truncate</span> ims_ewei_shop_order_peerpay_payinfo<span class="token1">;</span>
<span class="token6">truncate</span> ims_ewei_shop_order_refund<span class="token1">;</span>
<span class="token6">truncate</span> ims_ewei_shop_order_single_refund<span class="token1">;</span>
<span class="token4">-- 会员相关</span>
<span class="token6">truncate</span> ims_ewei_shop_member_log<span class="token1">;</span> <span class="token4"># 财务-财务-充值记录 (会员充值记录)</span>
<span class="token6">truncate</span> ims_ewei_shop_member_credit_record<span class="token1">;</span> <span class="token4"># 财务-明细-积分明细/财务明细</span>
<span class="token4">-- 拼团相关</span>
<span class="token6">truncate</span> ims_ewei_shop_groups_order<span class="token1">;</span> <span class="token4"># 拼团订单表</span>
<span class="token4">-- 积分商城</span>
<span class="token6">truncate</span> ims_ewei_shop_creditshop_log<span class="token1">;</span> <span class="token4"># 积分商城订单</span>
<span class="token4">-- 游戏营销</span>
<span class="token6">truncate</span> ims_ewei_shop_lottery<span class="token1">;</span> <span class="token4"># 营销活动设定表</span>
<span class="token6">truncate</span> ims_ewei_shop_lottery_default<span class="token1">;</span> <span class="token4"># 游戏营销入口设置</span>
<span class="token6">truncate</span> ims_ewei_shop_lottery_join<span class="token1">;</span>
<span class="token6">truncate</span> ims_ewei_shop_lottery_log<span class="token1">;</span>
```
```
