Mysql 修改指定日期范围内日数据为随机日期

    技术2023-06-13  73

    UPDATE `review` SET `created_at` = DATE_ADD('2016-1-01', INTERVAL ROUND(RAND() * 500 + 1) DAY) WHERE `created_at` > '2020-01-01';

     

    Processed: 0.012, SQL: 9