Mysql : - select count(*) [tablename]; PHP :- mysql_num

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

Question Posted / manish gupta

Answer Posted / manish gupta

Mysql : - select count(*) [tablename];
PHP :- mysql_num_rows();

Is This Answer Correct ?

14 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What language does mysql use?

831

What do you understand by mysql terminal?

983

How to include numeric values in sql statements?

942

How can we get the number of rows affected by query?

987

Is mysql same as mariadb?

851

What is the role of a limit in a mysql query?

946

What is the date format in mysql?

820

can you elaborate on blob and text in mysql? : Mysql dba

843

What is myisam?

907

What is database clustering in mysql?

950

How do I connect to mysql database?

962

What is data type for image in mysql?

824

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1328

What do ddl, dml, and dcl stand for?

850

What are the difference between now and current_date in mysql?

1293