mysql 常用的sql语句

1、查看数据库各个表中的记录数

USE information_schema;

SELECT table_name,table_rows 
FROM tables
WHERE TABLE_SCHEMA = 'testdb'
ORDER BY table_rows DESC;
04-16 01:14