สามารถใช้คำสั่งดังนี้ SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘{your_db}’; หรือ SELECT TABLE_NAME,SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = ‘your_db’ GROUP BY TABLE_NAME; code php <? $dtb = mysql_query(“SHOW TABLES”) or die (mysql_error()); $jmltbl = 0; $jml_record = 0; $jml_record = 0; while ($row = mysql_fetch_array($dtb)) { $sql1 = mysql_query(“SELECT * FROM ” . $row[0]); $jml_record = …Continue reading