Count table rows

by 
SELECT COUNT(*) FROM fooTable;

will count the number of rows in the table.

See the reference manual.

More Related Contents:

  1. How do I specify unique constraint for multiple columns in MySQL?
  2. SELECTING with multiple WHERE conditions on same column
  3. grant remote access of MySQL database from any IP address
  4. Should MySQL have its timezone set to UTC?
  5. JDBC batch insert performance
  6. SQL – Update multiple records in one query
  7. How to find gaps in sequential numbering in mysql?
  8. Can I create view with parameter in MySQL?
  9. MySQL: Invalid use of group function
  10. How to store IPv6-compatible address in a relational database
  11. Scaling solutions for MySQL (Replication, Clustering)
  12. MySQL show status – active or total connections?
  13. MySQL dynamic pivot table
  14. mysql check if numbers are in a comma separated list
  15. mySQL DataSource on Visual Studio 2012
  16. MySQL update case help
  17. Dropping Unique constraint from MySQL table
  18. Sorting by date & time in descending order?
  19. passing LIMIT as parameters to MySQL sproc
  20. What is the difference between BIT and TINYINT in MySQL?
  21. MySQL ERROR 1290 (HY000) –secure-file-priv option
  22. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  23. MySQL, Concatenate two columns
  24. Is it Possible to Enforce Data Checking in MySQL using Regular expression
  25. Import MySQL dump to PostgreSQL database
  26. How to select data where a field has a min value in MySQL?
  27. MYSQL declaring variables
  28. MySQL errorno 121
  29. Force MySQL to return duplicates from WHERE IN clause without using JOIN/UNION?
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment