Count table rows

What is the MySQL command to retrieve the count of records in a table?

Solution

SELECT COUNT(*) FROM fooTable;

will count the number of rows in the table.

See the reference manual.

PHP: log a user out
Laravel Eloquent Query - limit on a count()
MySQL Online DDL changes completing, but not persisting
phpMyAdmin says no privilege to create database, despite logged in as root user
SQL_MODE and TIME_ZONE when creating DATABASE
Spring boot migration 1.5.x to 2.x, H2 database 1.4.200 version throwing syntax error in alter command
Count table rows
Can't manage to make multiple averages with SQL
Getting to know a new web system that requires new features
How to import database inside dockerfile?
MySQL NOT IN () does not exclude wenn connecting 2 Tables
How to force an event to execute in MySQL
pip install mysqlclient returns "fatal error C1083: Cannot open file: 'mysql.h': No such file or directory
MySQL Match Against with Multiple Values to AGAINST
import mysql database to wamp server
Convert Unix timestamp into human readable date using MySQL
mysql query optimization steps or how to optimze query
Copying table structure to manage large number of rows in MySQL
PHPMyAdmin Configuration not working because of MySQL user password?
Subtract quantity from some entry in base of the DATE in MySql database
UTF8 MySQL problems on Rails - encoding issues with utf8_general_ci
How to update "updatedAt" manually?
How to SELECT the last 10 rows of an SQL table which has no ID field?
Selecting data from table based on date
maxscale cannot find gtid_binlog_pos
MySQL SUM of one column, DISTINCT of ID column
Deleting records before a certain date
Sort MySQL query data by calculated values
How to view/identify which process taking how much memory?
Bad Sql Grammar exception in JDBC spring