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 do you start and stop MySQL on Windows?

3 Answers  

What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?

1 Answers  

What is the use of innodb in mysql?

0 Answers  

What is 'mysqlimport'?

0 Answers  

how do i list constraints in my database by using sql server2000?

1 Answers  




How database are managed?

0 Answers  

How is data stored in mysql?

0 Answers  

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 Answers  

Can foreign key have duplicate values?

0 Answers  

What can you do with mysql?

0 Answers  

How do I start mysql client?

0 Answers  

What is the size of mysql database?

0 Answers  

For more MySQL Interview Questions Click Here
Categories