生成时间随机数sql

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;