MYSQL between用法

#测试用户 数据初始化
UPDATE `tp_users` SET user_money=10000,mall_money=500,total_amount=0,distribut_money=0 WHERE user_id <8;
DELETE FROM `tp_comment` WHERE username BETWEEN '15828194001' AND '15828194008';#评论 引号取决于字段是 int还是 string
DELETE FROM `tp_account_log` WHERE user_id BETWEEN 1 AND 8;#日志表 不包含右边界 相当于 1<=user_id<8 
DELETE FROM `tp_user_distribution_order` WHERE dis_user_id BETWEEN 1 AND 8;#账单表
DELETE FROM `tp_withdrawals` WHERE user_id BETWEEN 1 AND 8;#提现表
DELETE FROM `tp_order_goods` WHERE order_id IN (SELECT `order_id` FROM `tp_order` WHERE `user_id` BETWEEN 1 AND 8);#订单-商品表
DELETE FROM `tp_order_action` WHERE order_id IN (SELECT `order_id` FROM `tp_order` WHERE `user_id` BETWEEN 1 AND 8);#订单-操作记录表
DELETE FROM `tp_order` WHERE user_id BETWEEN 1 AND 8;#订单表
DELETE FROM `tp_user_address` WHERE user_id BETWEEN 1 AND 8;#地区表
DELETE FROM `tp_cart` WHERE user_id BETWEEN 1 AND 8;#购物车
DELETE FROM `tp_return_goods` WHERE order_id IN (SELECT `order_id` FROM `tp_order` WHERE `user_id` BETWEEN 1 AND 8);#退货表
DELETE FROM `tp_user_extend` WHERE user_id BETWEEN 1 AND 8;#发票表
DELETE FROM `tp_recharge` WHERE user_id BETWEEN 1 AND 8;#充值表