2023年8月3日发(作者：)

MYSQL进⾏批量操作删选和修改sql语句修改UPDATE t_user SET end_date = ‘2019-6-10 23:59:59’ WHERE uid IN ((SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b ))步骤：1、按条件查询出数据将查询结果作为中间表SELECT uid from t_user WHERE username LIKE ‘wtm05%’2、再查询⼀次中间表作为结果集(SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b）3、进⾏更新数据UPDATE t_user SET end_date = ‘2019-6-10 23:59:59’ WHERE uid IN ((SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b))

2023年8月3日发(作者：)

MYSQL进⾏批量操作删选和修改sql语句修改UPDATE t_user SET end_date = ‘2019-6-10 23:59:59’ WHERE uid IN ((SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b ))步骤：1、按条件查询出数据将查询结果作为中间表SELECT uid from t_user WHERE username LIKE ‘wtm05%’2、再查询⼀次中间表作为结果集(SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b）3、进⾏更新数据UPDATE t_user SET end_date = ‘2019-6-10 23:59:59’ WHERE uid IN ((SELECT uid FROM(SELECT uid from t_user WHERE username LIKE ‘wtm05%’) b))