List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:March 7 2006 2:10pm
Subject:Re: Merge tables: how to know the base tables?
View as plain text  
Hi,

> Simple way is show table status; there is a column Type : value MRG_MyISAM
is the base table.

No, that's not what I meant -- I meant, the merge
table uses a UNION clause to get signal where it
get it's data from.

Where can I get the sources for the merge table?
That is, what is used in the UNION clause when
creating it.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

> --Praj
>
> On Tue, 7 Mar 2006 14:02:44 +0100
> "Martijn Tonies" <m.tonies@stripped> wrote:
>
> > Hi there,
> >
> > How do you know what the sources are for a MERGE
> > table?
> >
> > SHOW TABLE STATUS doesn't show it, as far as I
> > can see?
> >
> > Is it really only available in SHOW CREATE TABLE?

Thread
Merge tables: how to know the base tables?Martijn Tonies7 Mar
  • Re: Merge tables: how to know the base tables?Prasanna Raj7 Mar
  • Re: Merge tables: how to know the base tables?Martijn Tonies7 Mar
    • Re: Merge tables: how to know the base tables?Prasanna Raj7 Mar