'How do I populate list of date range, but with AM & PM into an empty table (MySQL)?
For example
Date
| Date | Clock |
|---|---|
| 2022-03-20 | AM |
| 2022-03-20 | PM |
| 2022-03-21 | AM |
| 2022-03-21 | PM |
| 2022-03-22 | AM |
| 2022-03-22 | PM |
There seems to be good solution pertaining to using procedure but my version of MySQL is pretty old and does not have procedure to assist me, so a pure Insert statement is required.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|