Question: Write a SQL query to find the total count of rows in each table of a database.Answer: SELECT table_name, COUNT(*) FROM information_schema.tables GROUP BY table_name; |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is SQL?
- What is the difference between SQL and MySQL?
- What is a primary key?
- What is an index in a database?
- What is a foreign key?