Mysql method to query the number of rows in a table: 1. Use the "SELECT" statement to query all data in the specified table; 2. Use the COUNT() function to count the number of rows in the query results. The syntax is "SELECT COUNT (*) FROM table_name;".
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
The number of rows in mysql query table
1. Get the number of rows in a single table
SELECT COUNT(*) FROM table_name;
2. Get the number of rows in multiple tables (you can use the UNION operator to combine the result set returned by each SELECT statement)
SELECT 'tablename1' tablename, COUNT(*) rows FROM table_name1UNION SELECT 'tablename2' tablename, COUNT(*) rows FROM table_name2;
3. Get all tables of a database The number of rows (the information_schema method is sometimes inaccurate)
use information_schema; select table_name,table_rows from tables where TABLE_SCHEMA = 'db.name' order by table_rows desc;
[Related recommendations:mysql video tutorial]
The above is the detailed content of How to query the number of rows in a table in mysql. For more information, please follow other related articles on the PHP Chinese website!