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

Answer Posted / manish gupta

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

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I start mysql client?

508


What is ndb in mysql?

515


What are string data types?

565


What is the use of mysqli_query?

441


How many primary keys can be there in a table?

531






What is 'mysqlcheck'?

565


How do I run a query in mysql?

475


How to check server status with 'mysqladmin'?

524


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

568


What is the use of mysqli_connect in php?

467


What are the advantages of MySQL when compared with Oracle?

533


what is a cursor? : Mysql dba

477


How to create table with same structure of student table in mysql?

461


What you can use regular expression for in mysql?

478


What does "i_am_a_dummy flag" do in mysql?

491