locker — 2011-07-12T09:20:03-04:00 — #1
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?
guelphdad — 2011-07-12T10:39:15-04:00 — #2
SHOW TABLE STATUS FROM databasename
see the manual for more details.
locker — 2011-07-12T11:52:26-04:00 — #3
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.