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

Answer Posted / sunil kumar

Hello Manish bheiya, I tried ur answer but its not run on my
PC and then I tried this query

select count(*) as row from tablename

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write a query to find duplicate rows in table?

485


Is mongodb faster than mysql?

497


What are the two types of queries?

437


What is mysql root?

485


How do I free up space in mysql?

484






What is a query in mysql?

474


How many triggers are possible in mysql?

501


How we can get distinct columns values in mysql?

597


How to create a table?

547


How does mysql store data?

515


What does blob mean in mysql?

484


What are programming functions?

477


How do I start and stop mysql server?

468


Is mysql free for enterprise?

485


What is the difference between truncate and delete in mysql?

529