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

What are views in mysql?

872

How to present a past time in hours, minutes and seconds?

984

How do I update a variable in mysql?

884

What are the three types of queries?

849

Explain about the architecture of MYSQL?

928

What is difference between oracle and mysql?

886

How to load a csv file into a table

977

What can I do with mysql?

858

What are triggers mysql?

841

What is action query?

839

Explain % and _ inside like statement?

950

How do you name a table?

830

Can you tell how many values can set the function of mysql to consider?

925

how to display nth highest salary from a table in a mysql query? : Mysql dba

999

Who owns mysql database?

987