Did you try a self-join?

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #324,617 by static 4/13/10 8:17:00 PM Reply	Did you try a self-join? It feels wierd the first time you do it, but when it works you start wondering what all the fuss was about. `update subscribers s1 inner join subscribers s2 on s1.email = s2.email and s2.list_ID = 'baz' set s1.IP = s2.IP where s1.IP = 'bar' and s1.listID = 'foo'` Wade. Q:Is it proper to eat cheeseburgers with your fingers? A:No, the fingers should be eaten separately.
Post #324,620 by drook 4/13/10 9:23:05 PM Reply	Not yet, but about to This is what happens when you don't write code for a while. You forget the elegant way. -- Drew

Dumb SQL question - (drook) - (12) - April 13, 2010, 08:38:58 AM EDT

My lazy way - (crazy) - (3) - April 13, 2010, 11:23:53 AM EDT

You have ... - (beepster) - (2) - April 13, 2010, 01:26:55 PM EDT

Depends - (crazy) - (1) - April 13, 2010, 02:05:59 PM EDT

Maybe not so simple then - (drook) - April 13, 2010, 03:10:33 PM EDT

Did you try a self-join? - (static) - (1) - April 13, 2010, 08:17:00 PM EDT

Not yet, but about to - (drook) - April 13, 2010, 09:23:05 PM EDT

And then there is the (ugly) semi-manual way - (CRConrad) - (5) - Sept. 15, 2010, 08:07:41 PM EDT

This is also good for invasive updates. - (static) - Sept. 15, 2010, 08:14:45 PM EDT

That's my kind of ugly - (drook) - (2) - Sept. 15, 2010, 09:12:21 PM EDT

It's also an interesting lesson in pragmatism. - (static) - (1) - Sept. 15, 2010, 09:17:00 PM EDT

I've done round trips mySQL -> vim -> PHP -> mySQL - (drook) - Sept. 15, 2010, 09:27:26 PM EDT

Another batching method - (jay) - Sept. 15, 2010, 11:25:34 PM EDT

Real live veggie burgers -- they cook 'em 'til they're pink.
40 ms