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

How you can create a trigger in mysql?

999

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

1387

What is a procedure example?

925

What is select query in mysql?

910

Does mysql automatically index foreign keys?

926

Can we store videos in mysql database?

936

Which datatype is used for email in mysql?

958

How does php communicate with mysql?

908

Is mysql a backend?

928

What is different between sql and mysql?

1017

Is mysql deprecated?

918

How many columns is too many mysql?

905

Does facebook still use mysql?

932

Does mysql use sql?

889

Is mysql a framework?

924