select count(*) from tablename

How can we find the number of rows in a table using MySQL?

Question Posted / maha

Answer Posted / maha

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Is sqlite faster than mysql?

993

How do I connect to mysql database?

1092

What is row locking in mysql?

1020

What is session variable in mysql?

1023

How do I copy a table in mysql?

989

How do I declare a variable in mysql?

1012

How to enter numeric values as hex numbers?

1035

What is view? How can you create and drop view in mysql?

1000

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1503

Where is mysql used?

1034

How MySQL Optimizes DISTINCT?

1167

What does mysql_query return?

1108

What is row level locking in access?

934

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1171

What is mysql database used for?

1092