There is a mysql table into which you need to fill in the test data for the chart. The graph will show the dynamics of a certain value during the year, so it is necessary that each line in the table has a date for a new day. for example, the date in the first line “July 22, 2017” in the second “July 23, 2017” and so on - one day - one line. Wrote a small stored procedure for this:

delimiter // create procedure `testHistoryUpload`() begin set @a = 0; while (@a < 365) do insert into cashaccounts values ( 'q111', ROUND((RAND() * (100.22 - 10.93)) + 10.93), ROUND((RAND() * (150.67 - 10.93)) + 10.93), ROUND((RAND() * (10000.87 - 10.93)) + 10.93), '24.07.2016' // дата будет одна и та же ); set @a=@a+1; end while; end//

But I can not figure out the dates. Tell me who knows?

    1 answer 1

    The answer is found. In the loop instead of '24.07.2016' write adddate(now(), interval 1+@a day .