1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / pranab

Answers were Sorted based on User's Feedback



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

Answer / manish gupta

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

Is This Answer Correct ?    14 Yes 1 No

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

Answer / maha

select count(*) from tablename

Is This Answer Correct ?    1 Yes 1 No

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

Answer / sunil kumar

Hello Manish bheiya, I tried ur answer but its not run on my
PC and then I tried this query

select count(*) as row from tablename

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More MySQL Interview Questions

What is difference between group by and order by clause?

0 Answers  

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

0 Answers  

What are numeric data types?

0 Answers  

How to control the max size of a heap table?

0 Answers  

What is mysql gpl?

0 Answers  




How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

0 Answers  

What is user in mysql?

0 Answers  

Is mysql free for commercial use?

0 Answers  

What is blob datatype in mysql?

0 Answers  

What is the default port for mysql and how it can change?

0 Answers  

What is mysql sleep process?

0 Answers  

Is there an object-oriented version of MySQL library functions?

1 Answers  

For more MySQL Interview Questions Click Here
Categories