2015/03/04 09:21 -0500, Phil
One option would be to create a trigger for each milestone to generate the
data instead. That could be a lot of triggers, not sure if it could be
done in a single trigger, plus then I would have to maintain the trigger
when adding new milestones.
Less
- Original Message -
> From: "Phil"
> Subject: Capturing milestone data in a table
> user_credits where metric1 > $mile and (metric1 - lastupdate) < $mile)
That second where condition is bad. Rewrite it as metric1 < ($mile +
lastupdate). Better yet,
Hi mysql experts,
I feel like I'm missing something.
I'm trying to capture 'milestone' data when users pass certain metrics or
scores. The score data is held on the user_credits table and changes daily.
Currently just over 3M users on the table and their scores can range from 0
up to the 100's of
