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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
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
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
2010/4/7 Carsten Pedersen
> 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?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--0016362852fefbd90a0483b7414c
Content-Type: text/plain; charset=ISO-8859-1
On Thu, Apr 8, 2010 at 9:33 AM, spacemarc
> 2010/4/7 Carsten Pedersen
> > 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
--0016362852fefbd90a0483b7414c--