MySql count table rows

Question

Hello Stackoverflowers,

I'm a MySQL beginner. Does anybody know what the sql statment is to read how many recods their are in a MySql database? I don't want to display the records i just want to know how many records their are in my table.

Thanks

DJ

Answer 1

SELECT COUNT(*) FROM fooTable;

will count the number of rows in the table.

See the reference manual.

Answer 2

Simply:

SELECT COUNT(*) FROM `tablename`

Answer 3

select count(*) from YourTable