Re: Merge tables: how to know the base tables?
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]
Re: Merge tables: how to know the base tables?
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]
Re: Merge tables: how to know the base tables?
Hi Simple way is show table status; there is a column Type : value MRG_MyISAM is the base table. --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? > > 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Merge tables: how to know the base tables?
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? 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
