Mysql query to count the row values in rails

Question

Iam working in rails 3. i need count the row values from a mysql table.

In rails 3 i want to write that query in controller.

SELECT count(*) FROM #{table_name}

is that the correct query method.?

You can get it by using the count method for that Model. For ex: if your model name is User then User.count will fetch the number of rows in users table. — Amit Thawait
– Amit Thawait, Commented May 8, 2013 at 7:19

jbearden · Accepted Answer · 2013-05-08 17:17:20Z

2

You can count all the rows in a table easily with ActiveRecord. Let's use Post for your table name.

@posts = Post.all
@posts.count

Or like this:

Post.all.count

answered May 8, 2013 at 17:17

jbearden

1,8592 gold badges19 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1