In last week’s Getting Advanced Row Counts in MySQL (Part 2) blog we employed the native COUNT() function to tally unique values as well as those which satisfy a condition. In today’s final third instalment, we’ll learn how to obtain row counts from all of the tables within a database or entire schema.
In last week’s Getting Row Counts in MySQL blog we employed the native COUNT() function’s different variations to tally the number of rows within one MySQL table. In today’s follow-up, we’ll use the COUNT() function in more sophisticated ways to tally unique values as well as those which satisfy a condition.
There are several ways to get a row count in MySQL. Some database management products provide database statistics like table sizes, but it can also be done using straight SQL. In today’s tip, we’ll use the native COUNT() function to retrieve the number of rows within one table or view within a MySQL database. In part 2, we’ll learn how to obtain a row count from multiple tables, or even from all of the tables within a database.
When the Non-Essentials edition of Navicat Premium introduced the Code Snippets feature, writing queries against your preferred database type became easier than ever before. The Code Snippets feature allows you to insert reusable code into your SQL statements when working in the SQL Editor. Besides gaining access to a collection of built-in snippets, you can also define your own snippets. Today's blog will provide an overview of this exciting new feature.
Available in Non-Essentials editions of Navicat for MySQL, PostgreSQL, SQLite, MariaDB, and Navicat Premium, the Query Builder is a tool for creating and editing queries visually. Part 4 described how to include native SQL aggregate functions in your queries to display column statistics. This installment describes how to use the Query Builder to filter grouped data based on a HAVING condition.
- 2026 (1)
- April (1)
- March (1)
- The Hidden Costs of Cloud Database Services (and When On-Prem Makes More Financial Sense)
- How AI Code Completion Is Changing the Way DBAs Write SQL
- Role-Based Access Control in Database Environments: Getting It Right
- On-Prem vs. Cloud Database Hosting: How to Choose the Right Approach for Your Organization
- Getting Started with AI Assistants in Navicat On-Prem Server 3.1
- SQL vs. NoSQL: Choosing the Best Fit for Your Project
- February (1)
- What Metrics Actually Matter in Database Monitoring
- A Practical Guide to Database Transaction Isolation Levels
- Database Connection Pooling Explained
- Managing Database Credentials Securely
- Building Resilient Database Architectures
- The Future of Database Licensing Models: Navigating the Shift in How We Pay for Data Infrastructure
- January (1)
- Harnessing PostgreSQL Power: An Introduction to Supabase
- The ROI of Database Automation: Quantifying the Business Value of Automated Tuning, Patching, and Optimization
- Database Observability: The New Frontier in Performance Management
- The Database Skills Gap Crisis: Navigating the Shortage of Database Professionals
- The Economics of Multi-Cloud Databases
- 2025 (1)
- December (1)
- November (1)
- October (1)
- September (1)
- August (1)
- Going Beyond Basic Monitoring with Modern Database Observability Platforms
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- Privacy-Preserving Databases: Protecting Data While Enabling Access
- A Guide to Database Sharding as a Service
- July (1)
- June (1)
- The Rise of Embedded AI/ML Capabilities in Modern Databases
- Immutable Databases: the Evolution of Data Integrity?
- Seamless Information Access Through Data Virtualization and Federation
- Database DevOps Integration: Bridging the Gap Between Development and Operations
- Navicat Sponsors SQLBits 2025 – Supporting the Future of Data Platforms
- May (1)
- Edge Databases: Empowering Distributed Computing Environments
- The Rise of Low-Code/No-Code Database Interfaces: Democratizing Data Management
- Data Vault 2.0: A Modern Approach to Enterprise Data Modeling
- Streaming-First Architectures: Revolutionizing Real-Time Data Processing
- Navicat Proudly Sponsors PGConf.de 2025 as Silver Sponsor (Two Free Tickets Up for Grabs!)
- April (1)
- March (1)
- February (1)
- January (1)
- 2024 (1)
- 2023 (1)
- 2022 (1)
- 2021 (1)
- 2020 (1)
- 2019 (1)
- 2018 (1)
- 2017 (1)
