Hi,
>> 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.
I did think of SHOW CREATE TABLE, but it didn't turn up anything when I
tried it - now I know why. I'm using only version 3.23.32.
Do you know if this fix in 3.23.36 is only concerning the client utilities,
or would I have to upgrade my server too?
I still think the mapped tables should be shown in SHOW TABLE STATUS,
though...
Regards,
------------------------------------------------
Basil Hussain ([EMAIL PROTECTED])
---------------------------------------------------------------------
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
