Shulou(Shulou.com)05/31 Report--

Editor to share with you how to get the account balance of all users at a certain time through the change log in mysql, I believe most people do not know much about it, so share this article for your reference. I hope you will learn a lot after reading this article. Let's learn about it together.

Initialization data:

Select

Userid

Diamondcount-(select)

Sum (changeCount)

From

Account_log log

Where

Log.createtime > = '2016-06-22 10 0000'

And log.userid = a.userid) changecount

From

Account a

The above is all the contents of the article "how to get the account balance of all users at a certain time through the change log in mysql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.