MySQL Forums
Forum List  »  Merge Storage Engine

Re: Find Underlying Table From Merge Table?
Posted by: Mattias Bomelin
Date: January 27, 2007 07:19AM

I am also interested in a *real* solution from this.
Isn't there any other way then using union selects?

I have one mail table for each month, mail_year_month and a mail merge table.
If there was a way to SELECT id,sentdate,REAL_TABLE_NAME FROM mail_merge_table then i could convert my sentdate from DATETIME to TINYINT UNSIGNED and just store the day number and save some table space.

Using union selects in this case is too complicated since my merge table currently have over 60 underlying tables.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Find Underlying Table From Merge Table?
4541
January 27, 2007 07:19AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.