mysql TABLE_NAME, TABLE_COMMENT

SELECT TABLE_NAME, TABLE_COMMENT 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA='myschema' 
ORDER BY 1