如何计算mysql数据库中的表？

SELECT table_name FROM information_schema.tables WHERE table_schema = 'your_database_name';

SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = 'your_database_name';

SELECT table_name, table_rows, data_length, index_length, (data_length + index_length) AS total_size
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
ORDER BY total_size DESC;

SELECT table_name, table_rows
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
ORDER BY table_rows DESC;

SELECT table_name, column_count
FROM information_schema.tables
WHERE table_schema = 'your_database_name'
ORDER BY column_count DESC;