SELECT `TABLE_NAME` AS `name` , `TABLE_ROWS` AS `rows` , `DATA_LENGTH` + `INDEX_LENGTH` AS `size` FROM `information_schema` . `tables` WHERE `TABLE_SCHEMA` = ? AND `TABLE_TYPE` != ? ORDER BY TABLE_NAME 