Answers for "how to check how many tables in my database in mysql"

count of tables in database mysql

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

Posted by: Guest on November-10-2020

mysql check all tables

mysqlcheck -c mydatabasename -u root -p

Posted by: Guest on February-05-2021

Code answers related to "how to check how many tables in my database in mysql"