Hi there,
Does anyone know how to write this command for mysql version 4? (The command is for mysql version 5, I guess since when I check database in mysql server version4 there is no database name information_schema )

command:select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc;

meaning:show all database,table name and row count from all databases that has table row more than 1000000

Run result with mysql version 5:
mysql> select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc; +-------------------------------------+------------+
| table_name | table_rows |
+-------------------------------------+------------+
| waka2_dev.PYAT_TABLE_CELL_OLD | 110557706 |
| caap63_ded2.PIOFIT2 | 20052885 |

Run result with mysql version 4
mysql> select concat(table_schema,'.',table_name) as table_name,table_rows from information_schema.tables where table_rows > 1000000 order by table_rows desc;
ERROR 1146: Table 'information_schema.tables' doesn't exist

Anyone please helps
Thanks in advanced!

Seeing as this is a place for Linux specific questions, you'd be better served in a mysql forum or by doing a simple google search.

Aaaaand I forgot which forum I was in. Sorry about that.

ogin,

Hi there. As this is the second thread which you have removed from the zero-reply list by suggesting the OP would be better served in another forum, I am hereby asking kindly that you do not make the first reply to a brand new thread to suggest that the OP is posting his/her question in the wrong place.

If a question doesn't belong somewhere, please feel free to use the REPORT button and ask a moderator to have a look and/or to inform the OP that they might do better elsewhere. Alternately, just let it slide until there have been some other replies that attempt to address the issue.

Thanks and kind regards,

Sasha