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

Answer Posted / maha

select count(*) from tablename

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I change global variables in mysql?

471


How much does mysql enterprise cost?

481


What is row locking in mysql?

505


Does adding an index lock a table?

485


How many rows can be inserted in mysql at a time?

495






How do you shutdown a mysql database?

497


Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

497


Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

510


what is the difference between between and in operators in mysql?

496


What language is mysql written in?

501


What does mysql flush hosts do?

471


Why we use mongodb instead of mysql?

478


What is int unsigned?

497


How do I show users in mysql?

511


What is mysql57?

504