update 表名
set
时间字段名= FROM_UNIXTIME(UNIX_TIMESTAMP(DATE_ADD(DATE_ADD(‘2020-10-01 10:00:00’,INTERVAL FLOOR(1+RAND() * 28800) SECOND), INTERVAL FLOOR(1+RAND() * 90) DAY)),’%Y-%m-%d %T’)
WHERE id between 1 AND 129104;
生成时间随机数sql
最新推荐文章于 2021-09-02 21:03:34 发布