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...

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

Answer Posted / manish gupta

Mysql : - select count(*) [tablename];
PHP :- mysql_num_rows();

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does mysql clustering work?

909


how can you test for null values in a database? : Mysql dba

928


How to delete the repeated records from a table?

965


What is ddl, dml, and dcl?

976


How do I delete a mysql user?

841


Why do we use views instead of tables?

880


What is query design?

901


What is int unsigned?

928


How to display nth highest salary from a table in a mysql query?

986


Why does mysql have so many connections?

881


How do I start mysql?

884


How to calculate expressions with sql statements?

1108


How to show all records starting with the letters 'sonia' and the phone number '9876543210'

930


Are stored procedures precompiled?

973


Hi Team, This is kartik, I recently completed my B-tech. Importance of posting this question is for to know the best books on SQL(MYSQL/Oracle)? I like SQL concept's so much, at the same time i decided to choose SQL for my career purpose. So please suggest me the best books that are very helpful for a fresher to improve concepts like (SQL/PLSQL)Basics, programming concepts, architectures etc. Please consider my request as an important one. I am very thankful to you for providing this opportunity. If possible can you please send the names of books for my personal id also: karthikgdv1206@yahoo.com. Thanks, Kartik T

2226