UPDATE basicsale_b2b2c.basic_customer SET registerDate = ( from_unixtime( unix_timestamp('2017-01-01') + floor( rand() * ( unix_timestamp('2019-03-18') - unix_timestamp('2017-01-01') + 1 ) ) ) )
mysql设置时间段内随机时间
最新推荐文章于 2024-04-08 20:36:19 发布
UPDATE basicsale_b2b2c.basic_customer SET registerDate = ( from_unixtime( unix_timestamp('2017-01-01') + floor( rand() * ( unix_timestamp('2019-03-18') - unix_timestamp('2017-01-01') + 1 ) ) ) )