Oh yeah got it u meant UNION clause . Still i have no idea about that i usally see it in show create tables statements .
Sorry :( --Praj On Tue, 7 Mar 2006 15:10:51 +0100 "Martijn Tonies" <[EMAIL PROTECTED]> wrote: > 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" <[EMAIL PROTECTED]> 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? > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
