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 is myisamchk?

1022

What are the difference between now and current_date in mysql?

1523

What are all the Common SQL Function?

1206

How to update a root password.

998

What is a simple query?

945

Which is better mysql or mssql?

976

How do I clear the screen in mysql?

1038

How do I install mysql on windows 10?

1027

How to add a new column to an existing table in mysql?

1040

What is back end and front end?

950

How many columns is too many mysql?

953

How can you create and drop view in mysql?

968

What is mysql procedure?

976

How to return query output in xml format?

1080

How do you use auto increment?

972