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 mysql and mysqli?

1 Answers  

What is a result set object?

1 Answers  

Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

1 Answers  

Explain MySQL architecture?

1 Answers  

What is the maximum number of records in mysql table?

1 Answers  

What is dirty read and phantom read?

1 Answers  

How do I select a database in mysql workbench?

1 Answers  

How do I change directories in mysql?

1 Answers  

How to drop an existing table in mysql?

1 Answers  

What is 'mysqlcheck'?

1 Answers  

What is a heap table?

1 Answers  

What is a mysql model?

1 Answers  

For more MySQL Interview Questions Click Here
Categories