On Sat, Jul 19, 2008 at 4:18 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 18, 2008 at 3:46 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>> I'm sure there is a way to write this in a single query, but I bet it
>> it is ugly as heck, probably with a bunch of derived tables.
>
> INSERT INTO
On 7/19/08, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>
> On Sat, Jul 19, 2008 at 6:54 AM, Jake Peavy <[EMAIL PROTECTED]> wrote:
> > I may be wrong, but I think you could accomplish this through the use of
> > triggers. Triggers are designed to monitor data change activity.
> >
> > -jp
>
>
> Good tho
On Sat, Jul 19, 2008 at 6:54 AM, Jake Peavy <[EMAIL PROTECTED]> wrote:
> I may be wrong, but I think you could accomplish this through the use of
> triggers. Triggers are designed to monitor data change activity.
>
> -jp
Good thought. Using triggers to keep track of changes in an
intermediary tab
On 7/18/08, Jason Yergeau <[EMAIL PROTECTED]> wrote:
>
> Hi Rob ---
>
> MySQL 5.
>
>
>
> On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> > On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]>
> wrote:
> >> I'm having trouble working through a data problem. A
On Sat, Jul 19, 2008 at 4:18 AM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 18, 2008 at 3:46 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
>> I'm sure there is a way to write this in a single query, but I bet it
>> it is ugly as heck, probably with a bunch of derived tables.
>
> INSERT INTO
On Fri, Jul 18, 2008 at 3:46 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> I'm sure there is a way to write this in a single query, but I bet it
> it is ugly as heck, probably with a bunch of derived tables.
INSERT INTO balances (userid, points)
SELECT users.userid, users.points
FROM users
LEFT JOI
On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote:
> I'm having trouble working through a data problem. Any tips or
> keywords that might clue me into a known pattern would be incredibly
> appreciated!
>
> I have about 500,000 users in my system. Each user has a points
> ba
Hi Rob ---
MySQL 5.
On Fri, Jul 18, 2008 at 3:01 PM, Rob Wultsch <[EMAIL PROTECTED]> wrote:
> On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote:
>> I'm having trouble working through a data problem. Any tips or
>> keywords that might clue me into a known pattern would be
On Fri, Jul 18, 2008 at 2:00 PM, Jason Yergeau <[EMAIL PROTECTED]> wrote:
> I'm having trouble working through a data problem. Any tips or
> keywords that might clue me into a known pattern would be incredibly
> appreciated!
>
> I have about 500,000 users in my system. Each user has a points
> ba
I'm having trouble working through a data problem. Any tips or
keywords that might clue me into a known pattern would be incredibly
appreciated!
I have about 500,000 users in my system. Each user has a points
balance, updated by a system over which I have no control. I'd like
to track changes t
10 matches
Mail list logo