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

What is the use of mysql_close()?

510


Tell us something about heap tables?

547


How do I restore a mysql database dump file in linux?

483


Why we use mysql workbench?

469


What does mysql flush tables do?

507






Is mysql same as mariadb?

475


Who developed mysql?

562


How can I see connections in mysql?

475


How to get the number of rows selected or affected by a sql statement?

505


What is mysql workbench used for?

507


What is mysql cursor?

500


How to create a new table in mysql?

531


How do I delete a mysql user?

461


What is the function of mysqldump?

568


In which language it is written?

520