MYSQL between用法

最新推荐文章于 2025-08-01 14:13:57 发布

drzdryse

最新推荐文章于 2025-08-01 14:13:57 发布

阅读量3.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： MySql

本文链接：https://blog.youkuaiyun.com/m0_37711659/article/details/80431944

MySql 专栏收录该内容

5 篇文章

订阅专栏

本文提供了一组SQL脚本，用于清除和初始化特定用户ID范围内的数据，包括更新用户资金状态、删除评论、日志记录、订单信息及相关联的数据表记录。

#测试用户数据初始化
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;#充值表