'Fill Random data into Mysql Table with date and time
I need help to fill random_data (between 0.750 to 0.775) for particular member_id with date and time stamp with 15 min increment start from particular date, Let's say Jan 15, 2018 to May 10, 2022
data_id member_id random_value Fixed_value Date_Time
5 2 0.752 5 2022-05-12 05:02:45 4 1 0.751 5 2022-05-12 05:02:30 3 2 0.754 5 2022-05-12 05:02:15 2 1 0.751 5 2022-05-12 05:02:00 1 2 0.751 5 2022-05-12 05:01:45
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|