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

How do I edit a table in mysql?

895

What is the purpose of using a heap table?

1118

Is pdo faster than mysqli?

895

How can you see all indexes defined for a table?

1118

What is mysqli_result?

944

What is sqlyog?

1028

How will show all records containing the name "sonia" and the phone number '9876543210'

906

Does mysql case matter?

906

How do I kill a mysql connection?

905

What causes mysql too many connections?

962

How to delete a column and add a new column to database

944

What does mysqli_fetch_assoc do?

914

Are stored procedures precompiled?

985

How do you shutdown a mysql database?

1049

What are the advantages of MySQL when compared with Oracle?

928