Mysql update query/procedure

Question

I have a table with 2 columns, user and userMessage with table name as Messages I have another table with 2 columns as user and userMessageCount with table name as MessageCount. I am very new to programming. I need to write an update query or procedure something that will count the number of messages per user from Messages and store the count in MessageCount.

I am not able to understand the proper way of doing this. I understand this is a very basic question and I should study to solve this. i am running very late for a deadline. Please help me on this query.

What do you want? query or procedure? What you have done so far? — Mithun Sreedharan
– Mithun Sreedharan, Commented Oct 25, 2012 at 7:16

xray1986 · Accepted Answer · 2012-10-25 07:06:00Z

3

Insert Into MessageCount 
Select user, count(*)
From Messages
Group by user

answered Oct 25, 2012 at 7:06

xray1986

1,1683 gold badges10 silver badges28 bronze badges

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

1 Comment

Sushant Gupta Over a year ago

Exact answer. You understood me perfectly.

Collectives™ on Stack Overflow

Mysql update query/procedure

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related