Tuesday, May 7, 2013

mysql query show all table name and count table in a database mysql

how to show all table name mysql query
SELECT table_name FROM information_schema.tables WHERE table_type = 'base table' AND table_schema='database_name';
and

how to show total table mysql query

SELECT count(*) FROM information_schema.tables WHERE table_type = 'base table' AND table_schema='database_name';

No comments:

Post a Comment