Oh yeah got it u meant UNION clause .
Still i have no idea about that i usally see it in show create tables statements .
On Tue, 7 Mar 2006 15:10:51 +0100
"Martijn Tonies" <m.tonies@stripped> wrote:
> > 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
> Upscene Productions
> My thoughts:
> Database development questions? Check the forum!
> > --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?