Thread
:
Insert/ Update random date in MySQL
View Single Post
#
1
IP: 112.87.30.158
2015-04-19, 06:17 AM
Illiopolis
初级会员
Join Date: 2006-09-30
Posts: 1
Insert/ Update random date in MySQL
How would I update a column with a random date in the past 2 weeks using MySQL?
For example (code doesn't actually work):
Code:
UPDATE mytable SET col = sysdate()-rand(1,14);
Illiopolis
View Public Profile
Find all posts by Illiopolis