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 |
Is foreign key indexed mysql?
How do I restore a database in mysql workbench?
What is mysql database server?
How many rows can be inserted in mysql at a time?
What is the purpose of using timestamp data type?
What is ACID?
how to connect a php script with the mysql database?
what is the main difference between myisam and innodb
how to display only 4 records from a table based on a condition for ex i have a table called products in that nid,prodname are fields i want to display only any 4 records of perticular product plz tell me
How does triggers work in mysql?
What is procedure in mysql?
What is the difference between myisam dynamic and myisam static in mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)