All Questions
1 question
0
votes
1
answer
133
views
Fill in the missing hours with insert and recursive left join
I have a table with temperatures.
Sometimes the message was not received and the information is missing.
I need to fill the missing rows with NULL for every hour.
CREATE TABLE temp_total(
id int(6) ...
- 742