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

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

Can foreign key have duplicate values?

0 Answers  


Can we store videos in mysql database?

0 Answers  


Can we join 3 tables in mysql?

0 Answers  


Which software is used for mysql?

0 Answers  


What happens if null values are involved in expressions?

0 Answers  






How do I update a variable in mysql?

0 Answers  


What are the technical features of MySQL?

0 Answers  


What is the difference between CHAR and VARCHAR data types?

2 Answers   Ramco,


What are federated tables?

0 Answers  


how many fields can be updated using set in a mysql query?

1 Answers  


How to returns the columns and column information pertaining to the designated table.

0 Answers  


What is a user defined variable?

0 Answers  


Categories