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

Question Posted / pranab

3 Answers
8286 Views
I also Faced
E-Mail Answers

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 load data files into tables with 'mysqlimport'?

0 Answers

In which language mysql has been written?

0 Answers

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

0 Answers

Is mysql a relational database?

0 Answers

What is a join? Explain the different types of mysql joins.

1 Answers

How do you concatenate strings in mysql?

0 Answers

Explain the difference between procedure and function in mysql?

0 Answers

What is myisamchk?

0 Answers

Is SET Command is SQL Statement..?