List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:April 8 2010 10:36am
Subject:Re: SHOW TABLE STATUS
View as plain text  
On Thu, Apr 8, 2010 at 9:33 AM, spacemarc <spacemarc@stripped> wrote:

> 2010/4/7 Carsten Pedersen <carsten@stripped>:
> > AFAIR, MySQL 4.x supports LIKE, e.g.
> >
> > SHOW TABLE STATUS LIKE 'tab_%'
>
> yes, but if the tables have different names (table1, tab_2, abcd... )
> your syntax will not work. How to do?
>

Multiple statements. Remember, "show table status" is not SQL, it's a
command to the mysql server. Regular SQL constructs do not apply.



-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
SHOW TABLE STATUSspacemarc7 Apr
  • Re: SHOW TABLE STATUSCarsten Pedersen7 Apr
    • Re: SHOW TABLE STATUSspacemarc8 Apr
      • Re: SHOW TABLE STATUSJohan De Meersman8 Apr