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

Can we save images in mysql database?

466

What is full form of xampp?

539

Can we store images in mysql database?

482

How to insert dynamic values in mysql using php?

537

How to see the create table statement of an existing table?

576

What are the different data types in mysql?

471

What is processlist in mysql?

494

What is the use of pdo?

509

How do I fix a crashed mysql database?

491

How can I create database in mysql?

498

How to get nth highest salary from table in a mysql?

527

Is sql and mysql same?

503

What is triggers and how it can be used in mysql?

526

Can you tell how many values can set the function of mysql to consider?

519

Is mysql server free?

487