Sign Up Login


  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

How to enter boolean values in sql statements?

0 Answers  

What is mysql57?

0 Answers  

What are mysql functions?

0 Answers  

What is difference between mysql mysqli and pdo?

0 Answers  

What is join in mysql? What are the different types of join?

0 Answers  

Why mysql is so popular?

0 Answers  

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

0 Answers  

How to show all tables with 'mysql'?

0 Answers  

Where is the mysql database stored?

0 Answers  

What mysql means?

0 Answers  

What is ntext?

0 Answers  

What are the disadvantages of stored procedures?

0 Answers  

For more MySQL Interview Questions Click Here
Categories