Test

SELECT CONCAT('<a href="javascript:void(0);" onclick="document.SQLForm.rSQL.value=\'SHOW FIELDS FROM `',TABLE_NAME,'`\';">',TABLE_NAME,'</a>') AS `SCHEMA`, CONCAT('<a href="javascript:void(0);" onclick="document.SQLForm.rSQL.value=\'SELECT * FROM `',TABLE_NAME,'`\';">',TABLE_ROWS,'</a>') AS `ROWS`, CONCAT(ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024, 1), 'K') AS `SIZE` FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'uyznoqdz_ifarm'

Leave a comment

Your email address will not be published. Required fields are marked *