Generate list of months in mysql

Question

I need to join an existing table with date entries with a list of months in a given period. For this I would need to temporary generate a list of months within this period.

Is there a command in mysql for doing this? Temporary Table, stored procedure?

Thx, martin

Answer 1

I'm not sure I fully understand your question, but something like this might be what your looking for:

select * from existing_table et join month_table mt on mt.month = month(et.date)