How can we find the number of rows in a table using MySQL?
Answers were Sorted based on User's Feedback
Mysql : - select count(*) [tablename];
PHP :- mysql_num_rows();
Is This Answer Correct ? | 14 Yes | 1 No |
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 |
Can foreign key have duplicate values?
Can we store videos in mysql database?
Can we join 3 tables in mysql?
Which software is used for mysql?
What happens if null values are involved in expressions?
How do I update a variable in mysql?
What are the technical features of MySQL?
What is the difference between CHAR and VARCHAR data types?
What are federated tables?
how many fields can be updated using set in a mysql query?
How to returns the columns and column information pertaining to the designated table.
What is a user defined variable?