Skip to content
Advertisement

MySQL or MariaDB spread Date range in single row into multiple series of rows

Example tables are below,

and example rows below,

What I want to get is convert table above to below so that I can join using each date in range.

Is there any way to extend date range in single row to series of Date row?

Advertisement

Answer

MariaDB 10.2+ or MySQL 8+ needed.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement