Count number of rows in a SQL table

Question
How do I get a count of how many rows are in a table?

Answer

Syntax

select count(*) from <tablename>

Example

select count(*) from pgcontenthdr

 Collapse All    Expand All

• Stored Procedures
  • Select Stored Procedure
  • Update Stored Procedure
  • Insert Stored Procedure
  • Delete Stored Procedure
• Views
  • Views 101
• Table Basics/ Database Dev
  • Zip file schema/data
  • Create SQL Table
  • Foreign Key Constraint
  • Data Types
  • Add Column
  • Drop Table
  • Create FK Constraint
• Cheatsheets
  • Date Functions
  • String Functions
• Other
  • Count Rows
  • MySQL Login

MySQL Information and Resources