MySQLでテーブル毎のデータ件数の確認

それぞれのテーブルに格納されているデータ件数を一度に纏めて表示する場合には次のSQLを発行すれば良い。

mysql> use information_schema;
mysql> select table_schema, table_name, table_rows from tables;

実行結果は次のようになる。

mysql	user	7
performance_schema	cond_instances	1000
performance_schema	events_waits_current	1000
performance_schema	events_waits_history	1000
performance_schema	events_waits_history_long	10000
performance_schema	events_waits_summary_by_instance	1000
performance_schema	events_waits_summary_by_thread_by_event_name	1000
performance_schema	events_waits_summary_global_by_event_name	1000
performance_schema	file_instances	1000
performance_schema	file_summary_by_event_name	1000
performance_schema	file_summary_by_instance	1000
performance_schema	mutex_instances	1000
performance_schema	performance_timers	5
performance_schema	rwlock_instances	1000
performance_schema	setup_consumers	12
performance_schema	setup_instruments	1000
performance_schema	setup_timers	4
performance_schema	threads	1000
sampleDb	sampleTbl	1
sampleDb	test1	0
testdb	emp	0
testdb	test	2