Answers for "how to count mysql database tables"

count of tables in database mysql

SELECT count(*) 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'database_name'

Posted by: Guest on November-10-2020

count mysql server db tables

SELECT count(*)
   FROM INFORMATION_SCHEMA.TABLES
   WHERE TABLE_SCHEMA = 'yourDatabaseName';

Posted by: Guest on September-12-2021

Code answers related to "how to count mysql database tables"