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 run a query in mysql?

706


How to drop an existing view in mysql?

718


Create table employee (eno int(2),ename varchar(10)) ?

728


How do I rename a table in mysql?

726


How do I view a mysql database?

664


What is mysql57?

690


Can you tell the difference between mysql_fetch_object and mysql_fetch_array?

722


How do I start mysql?

662


How do I flush privileges in mysql?

701


How do stored procedures work?

717


What is a tinyint in mysql?

676


How to dump one database for backup.

686


What are the advantages of mysql in comparison to oracle?

752


What is the difference between b-tree and hash indexes?

686


How do I create a stored procedure in mysql?

665