List:General Discussion« Previous MessageNext Message »
From:Carsten Pedersen Date:April 7 2010 6:44pm
Subject:Re: SHOW TABLE STATUS
View as plain text  
AFAIR, MySQL 4.x supports LIKE, e.g.

SHOW TABLE STATUS LIKE 'tab_%'

/ Carsten

spacemarc skrev:
> hi all,
> in MySQL 4.1.x i want to obtain the status of more tables with one only query.
> 
> In 5.x i use "SHOW TABLE STATUS WHERE Name IN ('tab_1', tab_2, 'tab_3')"
> 
> In 4.1.x i tried to use but it doesn't works: how to set the query?
> 
> Thanks
> 
Thread
SHOW TABLE STATUSspacemarc7 Apr
  • Re: SHOW TABLE STATUSCarsten Pedersen7 Apr
    • Re: SHOW TABLE STATUSspacemarc8 Apr
      • Re: SHOW TABLE STATUSJohan De Meersman8 Apr