Shulou(Shulou.com)06/01 Report--

The following brings you about how to apply the mySql variable, if you are interested, let's take a look at this article. I believe it will be of some help to you after reading how to apply the mySql variable.

-1. Customize a time variable and set it to the day before the current date SET @ startTime = CONCAT (date_sub (curdate (), interval 1 day),'%');-- you can also specify the date manually from here-- SET @ startTime = '2017-04-13% date-show the date to be queried-- select @ startTime Select REPLACE (@ startTime,'%','') as date, active users on that day, and new users from (--2. Query current-day active users select '01' as id,count (1) as from (select DISTINCT uname from app_loginLog where logindate like @ startTime) as t) as a,-- 3. Query new users on the same day (select '01' as id,count (1) as new users from app_user where registerdate like @ startTime) b

Where a.id = b.id

Read the details of how to apply the mySql variable above and see if there is anything to gain. If you want to know more about it, you can continue to follow our industry information section.

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.