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 are some good ideas regarding user security in MySQL?

2 Answers  

Can we write procedure in mysql?

0 Answers  

Does mysql support nosql?

0 Answers  

What are the mysql database files stored in system ?

0 Answers  

How you will Show unique records.

0 Answers  




Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  

What is trigger in mysql with example?

0 Answers  

What is sharding in mysql?

0 Answers  

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

1 Answers  

What is the use of pdo?

0 Answers  

What is a scalar function?

0 Answers  

What is the difference between database and table?

0 Answers  

For more MySQL Interview Questions Click Here
Categories