On 2025-Jul-17, zkbp712 wrote:
> Alternative (optional) syntax idea:
>
> INSERT INTO dosage (medication_id, amount, date)
> GENERATE RANGE (5, 3, '2025-04-01', '2025-04-30');
Here's a simple way to achieve this:
INSERT INTO dosage(medication_id, amount, date)
SELECT 5, 3, g
FROM generate_seri
Dear MySQL/PostgreSQL Development Teams,
My nameis T-RegExr (Tyrannosaurus RegExr), and I am a developer working
extensively withtime-series data such as medication dosages and other daily
records.
I would liketo propose a feature enhancement to simplify the insertion of
multiple rowsover a co