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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysql default port number?

749


How can you make a database as your current database?

693


What is striped backup

2014


Is mysql better than oracle?

675


What is query design?

659


Why do you think it is advised to not to use guid and character columns as clustered index arrays?

886


What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

732


How important is to list the column names when doing an insert?

787


What is the maximum connection pool size?

721


How many rows mysql can handle?

693


How do you rename a table?

691


Is mysql good for big data?

673


What port is mysql running on?

665


What is the difference between a heap table and temporary table?

690


How can you retrieve a particular number of records from a table?

686