Answers for "how to get no of tables in mysql"

SQL
1

count of tables in database mysql

SELECT count(*) 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'database_name'
Posted by: Guest on November-10-2020

Code answers related to "how to get no of tables in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language