Member Avatar for apanimesh061

I have a table ...
Ratings (userid, movieid, ratings, time)
where ...
select count(*) from ratings where userid = X; (No of ratings of a particular user)

Here, X ranges from 1-6040!

How should I get the count of each user and then store it in another table 'Users' in the attribute 'countUsers' ?

Please help !

  • 3 Contributors
  • 2 Replies
  • 107 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for aquilax

If you want to store the result into empty table:

INSERT INTO Users 
SELECT userid, count(*) 
FROM ratings 
GROUP BY userid
Member Avatar for debasisdas

Creating view is a better option for that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.