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 does mysql store data?

918

How do I install mysql?

884

How can you export the table as an xml file in mysql?

869

What is mysql server used for?

935

Is mysql port 3306 tcp or udp?

903

How do I rename a table in mysql?

955

Does mysql use tcp or udp?

903

how to Return total number of rows.

992

Write a query to find duplicate rows in table?

893

How do I run a query in mysql?

927

How to return query output in html format?

909

Does facebook still use mysql?

916

How do I edit a table in mysql workbench?

832

what is a cursor? : Mysql dba

989

Write a query to create a database and a table?

877