Hi,
On Fri, Apr 20, 2001 at 10:47:57AM +0100, Basil Hussain wrote:
> I think I may have come up against a slight niggling omission concerning
> Merge tables. How does one find out what physical tables are mapped, other
> than by looking at the contents of the .MRG file?
>
> Surely this information should be displayed either when you do SHOW TABLE
> STATUS or by some other means?
>
I never use SHOW TABLE STATUS, but you can use SHOW CREATE TABLE which
will give you the complete CREATE TABLE statement for the MERGE table.
This doesn't include the UNION part in MySQL 3.23.33, but I believe
this was fixed in MySQL 3.23.36 and later.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
