I have a MySql table which, simplified, looks like:
ID - int - auto_identity
iDate - Date
Ext - varchar(25)
Calls - int
AvgTalkMinutes - Decimal
Sample data would look like
1 2011-11-01 200 24 3.1532
It needs to expand to go into a table that has 1 record per call. Basically, I'm de-summarizing it -- I know, weird situation ... importing from a system that provides less data.
I want the output of some join to have, in this case 24 rows with
2011-11-01 200 3.1532
So, what can I join to in MySql to give me X rows? I believe dual serves that purpose in Oracle ... and elsewhere I've created a ListOfNumbers table just so I could join Where Number<=Calls.
Is an artificial ListOfNumbers table the best option in MySql? Or is there a better way?