Bug #26948 SHOW COLUMNS FROM table LIKE '%ver%'

• Submitted: 8 Mar 2007 6:16
• Modified: 4 Feb 2009 15:16
• Reporter: Hans Ginzel
• Status: Verified
• Category: MySQL Server: Parser
• Severity: S4 (Feature request)
• Version: 5.0.26-community-nt, 5.1
• OS: Windows (MS Windows XP)
• CPU Architecture: Any
• Tags: like, show

[8 Mar 2007 6:16] Hans Ginzel

Description:
There should be posiibility to limit the output of SHOW COLUMNS.

How to repeat:
SHOW COLUMNS FROM table_with_lots_of_columns

Suggested fix:
SHOW COLUMNS FROM table LIMIT 10;
SHOW COLUMNS FROM table LIMIT 10 OFFSET 5;
SHOW COLUMNS FROM table LIKE '%glob%';
SHOW COLUMNS FROM table REGEXP '%regexp%';
SHOW COLUMNS FROM table REGEXP '%regexp%' LIMIT 10;
...

[29 Apr 2007 12:44] Valeriy Kravchuk

Bug #27083 looks like a duplicate of this one.

[4 Feb 2009 15:16] Susanne Ebrecht

Many thanks for writing a feature request. Our development will discuss this.