I want to be able to select the 'Max_data_length' value for a table. I see that in MySQL 5 you can get this from the information_schema tables, but this is a MySQL 4.1.22 database and so those aren't available.
Anyone know how to do this?
SHOW TABLE STATUS FROM databasename
see the manual for more details.
guelphdad, thanks for that but I was looking to be able to use SELECT so that I could run the query in PHP and use the value to make some calculations.