Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

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

Question Posted / maha

Answer Posted / maha

select count(*) from tablename

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the differences between a primary key and foreign key?

1085

Which statement is used in a select query for partial matching?

1184

Does mysql use tcp or udp?

914

How to install mysql?

1013

Can varchar be primary key?

916

Write a query to count the number of rows of a table in mysql.

927

What is dirty read and phantom read?

872

How to include numeric values in sql statements?

998

Is pdo more secure than mysqli?

880

Is mysql still relevant?

903

How to execute mysql query in php?

906

Who owns mysql database?

1031

How to update database permissions/privilages.

968

How to create a new table by selecting rows from another table in mysql?

981

What are the other commands to know the structure of a table using mysql commands except explain command?

1023