Bug #7986 Syntactic sugar
Submitted: 18 Jan 2005 13:05 Modified: 14 Aug 2009 10:53
Reporter: Hans-Henrik Stærfeldt Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:1.4.5 OS:Any ((ALL))
Assigned to: CPU Architecture:Any
Triage: Needs Triage: D5 (Feature request)

[18 Jan 2005 13:05] Hans-Henrik Stærfeldt
Description:
The following syntatic sugar would be nice;

SHOW TABLE STATUS [FROM] db.table;

but also;

REPAIR TABLE [FROM db] LIKE '%tables';
SHOW CREATE TABLE [FROM db] LIKE '%tables';
ANALYZE TABLE [FROM db] LIKE '%tables';
CHECK TABLE [FROM db] LIKE '%tables' [option];
CHECKSUM TABLE [FROM db] LIKE '%tables' [option];
OPTIMIZE TABLE [FROM db] LIKE '%tables';

How to repeat:

SHOW TABLE STATUS db.table;

Suggested fix:

SHOW TABLE STATUS db.table;
[14 Aug 2009 10:53] Sveta Smirnova
Thank you for the reasonable feature request.