select count(*) from tablename

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

Question Posted / maha

Answer Posted / maha

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are date and time functions in mysql?

1070

How do I edit a database in mysql workbench?

954

What command is used to delete the data from the table without deleting the table structure?

1045

What is mysql vs sql?

1042

How to display top 10 rows in mysql?

1094

How do I install the latest mysql on ubuntu?

1045

How do I download mysql on my laptop?

951

What is myisamchk?

1026

What is 'mysqldump'?

1124

What is mysql url?

924

Write a query to fetch common records between two tables using mysql?

1071

How do you create a primary key?

1061

How do I edit a table in mysql workbench?

899

How many columns can you create for an index?

1003

How do I change global variables in mysql?

951