Bug #44321 SHOW TABLES documentation missing IN keyword
Submitted: 16 Apr 2009 13:15 Modified: 16 Apr 2009 13:52
Reporter: Kay Roepke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[16 Apr 2009 13:15] Kay Roepke 
Description:
The documentation at http://dev.mysql.com/doc/refman/5.1/en/show-tables.html specifies the use of FROM to do something like:
SHOW TABLES FROM db;

However, SHOW TABLES IN db; is also valid syntax.
Note: This applies to all SHOW commands where the documentation states you need to use FROM:
- COLUMNS (both FROM clauses)
-TRIGGERS
- EVENTS
- TABLE STATUS
- OPEN TABLES
- BINLOG EVENTS
- KEYS | INDEX | INDEXES

verified in 5.1.30 sql_yacc.c

How to repeat:
Look at documentation for SHOW TABLES
Execute SHOW TABLES IN mysql;

Suggested fix:
Mention that IN instead of FROM is also valid syntax.
[16 Apr 2009 13:37] Kay Roepke 
I mistakenly listed SHOW BINLOG EVENTS in the original report. This bug does _not_ apply to it.
Sorry :)
[16 Apr 2009 13:52] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.