I have written three queries for 3 bars in a bar graph, data for two bars is available, as I have no data for the third bar, instead of displaying 2 bars it is displaying an error. How can I get the value as Zero for the third bar in a bar graph.?
Please help me to write a MySQL time series query.
Does your 3rd query return an error? There is no option to ignore errors all your queries must return without error.
i mean there is no error in query syntax. but there is no data to retrieve in the third query.
maybe you have to report your data for longer period?