how to count numbar of mysql tables programmatically (c#)
This SQL query will help you
SELECT count(*) TABLES, table_schema FROM information_schema.TABLES WHERE table_schema= 'YOUR DATABASE NAME' GROUP BY table_schema
It gives the number of tables in the database you specify. Worked for me:)
I will use it in my code
We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.