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 show all tables in mysql query?

468


How do I create a new database in mysql?

472


How do I change directories in mysql?

472


How to delete a trigger in mysql?

483


How does limit work in mysql?

461






What is the phantom problem?

493


How can you validate emails using a single query?

451


What is striped backup

1822


What is mysql enterprise edition?

450


List some comparisons operators used in mysql?

523


What is a session in mysql?

479


What is the data type for file in mysql?

540


How is mysql database stored?

528


What is the use of mysql workbench?

510


What's the latest version of mysql?

500