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
How does mysql clustering work?
how can you test for null values in a database? : Mysql dba
How to delete the repeated records from a table?
What is ddl, dml, and dcl?
How do I delete a mysql user?
Why do we use views instead of tables?
What is query design?
What is int unsigned?
How to display nth highest salary from a table in a mysql query?
Why does mysql have so many connections?
How do I start mysql?
How to calculate expressions with sql statements?
How to show all records starting with the letters 'sonia' and the phone number '9876543210'
Are stored procedures precompiled?
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