Query to count the number of tables I have in MySQL

by 
SELECT COUNT(*) FROM information_schema.tables WHERE table_schema="dbName";

Source

This is mine:

USE databasename; 
SHOW TABLES; 
SELECT FOUND_ROWS();

More Related Contents:

  1. SQL split values to multiple rows
  2. How do I escape reserved words used as column names? MySQL/Create Table
  3. How to store multiple options in a single table?
  4. How to populate a table with a range of dates?
  5. Get the new record primary key ID from MySQL insert query?
  6. What is the opposite of GROUP_CONCAT in MySQL?
  7. How to Perform an UPSERT so that I can use both new and old values in update part
  8. brew install mysql on macOS
  9. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  10. How do I check to see if a value is an integer in MySQL?
  11. Add 2 hours to current time in MySQL?
  12. Store image to database blob; retrieve from db into Picturebox
  13. MySQL trigger On Insert/Update events
  14. MySQL combine two columns into one column
  15. MySQL Insert Into from one Database in another
  16. How can I change MariaDB to MySQL in XAMPP?
  17. MySQL: LIMIT by a percentage of the amount of records?
  18. MySQL multiple columns in IN clause
  19. GROUP BY – do not group NULL
  20. Reserved word in column name – insert into MySQL [duplicate]
  21. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  22. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  23. FIND_IN_SET with multiple value [duplicate]
  24. Is MySQL Temporary table a shared resource?
  25. Comparing with NULL values
  26. How to kill MySQL connections
  27. `MODIFY COLUMN` vs `CHANGE COLUMN`
  28. Find method to store an IP in MySQL for better performance
  29. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  30. How to solve MySQL max_user_connections error

Leave a Comment