mysql查数据库的所有表名,表注释,表数据大小,表数据行数的sql语句:
(mydatabase 是数据库名)
SELECT table_name,table_comment,DATA_LENGTH,TABLE_ROWS
FROM information_schema.tables
WHERE table_schema = 'mydatabase';
mysql查数据库的所有表名,表注释,表数据大小,表数据行数的sql语句:
(mydatabase 是数据库名)
SELECT table_name,table_comment,DATA_LENGTH,TABLE_ROWS
FROM information_schema.tables
WHERE table_schema = 'mydatabase';