/* Show table names, num or rows, avg length, next auto_increment, etc. */ 


SELECT  table_name, table_rows, data_length, auto_increment, create_time, update_time, table_comment
FROM    information_schema.TABLES                               
WHERE   table_schema  =  'demo'               # belonging to schema 'demo'