In MySql,
If my procedure return details likeFromDate ToDate Data Value
----------------------------------------------
2004-01-01 2014-01-01 Data1 100
2014-01-01 2020-01-01 Data1 20
2014-01-01 2020-01-01 Data2 50
----------------------------------------------
Here for the time period [2004-01-01 to 2014-01-01] Data2 is missing.So how it possible to enter a row like
2004-01-01 2014-01-01 Data2 0
解决方案ther you are![^]
insert into table1 values('2004-01-01', '2014-01-01', 'Data2', 0)
mysql_insert[^]
Please check the query your stored procedure is using to return the results.
You will need to check if there is any filter condition applied to exclude such 0 valued records. If yes then remove it.
You will also have to check if any such data exists in the related table. If no then first ensure that your tables have the required data.