| 19:20.30 | *** join/#uphpu ibot (~ibot@rikers.org) |
| 19:20.30 | *** topic/#UPHPU is Utah PHP Users | uphpu.org |
| 19:20.31 | *** mode/#UPHPU [+v ibot] by ChanServ |
| 19:34.43 | ninnypants | can anyone see a reason this query would choke a server? http://pastebin.com/9VSBdz8J |
| 19:35.43 | jsmith | ninnypants: Upon quick glance, there are a lot of joins there |
| 19:36.04 | jsmith | ninnypants: I'm assuming you're using a fairly modern version of MySQL, and that you have indices created for the columns being joined against? |
| 19:36.30 | ninnypants | jsmith: I would hope so |
| 19:36.35 | jsmith | ninnypants: Have you looked at the output of EXPLAIN on that query? |
| 19:37.06 | ninnypants | I'm converting it for a server move they had an older version that broke when it ran on newer versions of msql |
| 19:37.49 | ninnypants | jsmith: no I'll try that I haven't gotten anything back if I run it through phpmyadmin the browser is stuck connecting, and if I run it through ssh it just stalls |
| 19:38.25 | jsmith | ninnypants: Start working on it join by join :-) |
| 19:39.19 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 19:41.27 | ninnypants | I'll have to was hoping I was just doing something obviously wrong |
| 19:44.21 | *** join/#uphpu PoeticIntensity (~jason@76.8.222.23) |
| 19:44.29 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 19:46.33 | ninnypants | hmm wonder if the return set was just to massive with how I was testing added a where clause and it started working |
| 19:46.59 | wps | I have an MySQL table where I need to set a value if the current value is NULL |
| 19:47.09 | wps | is there a way to do that in a single query |
| 19:47.27 | wps | instead of a SELECT, then an IF in PHP, and then an INSERT? |
| 19:48.12 | wps | waitâ¦Â that could probably just be in the WHERE |
| 19:48.24 | wps | INSERT INTO abc where column IS NOT NULL |
| 19:49.02 | ninnypants | wps couldn't you just run an update? |
| 19:49.13 | wps | sorry |
| 19:49.15 | wps | update is what I meant |
| 19:49.23 | wps | UPDATE table where column IS NOT NULL |
| 19:49.24 | *** join/#uphpu PoeticIntensity (~jason@76.8.222.23) |
| 19:49.24 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 19:49.43 | ninnypants | UPDATE tbl SET col = val WHERE col = null |
| 19:49.47 | ninnypants | something like that? |
| 19:49.56 | wps | sheeshâ¦Â yes :) |
| 19:50.03 | wps | where col = NULL |
| 19:50.04 | wps | you're right |
| 19:50.19 | wps | isn't it IS NULL though in MySQL? |
| 19:50.27 | wps | opposed to col=null |
| 19:50.37 | wps | or does either work? |
| 19:50.40 | ninnypants | not sure I don't do a ton of mysql |
| 19:51.02 | ninnypants | I do mostly WP it's made my sql skills go down hill |
| 19:53.34 | mahelious | in mysql it's IS NULL exclusively |
| 19:53.46 | wps | thanks, mahelious |
| 19:59.28 | beandog | wps: coalesce |
| 19:59.35 | wps | coalesce? |
| 19:59.44 | beandog | oh wait, maybe i misread |
| 19:59.56 | beandog | coalesce returns first non-null value though |
| 20:00.26 | beandog | yah I read that wrong. |
| 20:00.33 | beandog | Just do WHERE foo IS NULL; |
| 20:18.18 | *** join/#uphpu Monnok (~monnok@205.204.33.82) |
| 21:00.39 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 21:30.43 | josephscott | $8ball will it warm up for may? |
| 21:30.43 | raifbot | josephscott - Without a doubt. |
| 21:39.07 | *** join/#uphpu wps (~wps@75-169-241-232.slkc.qwest.net) |
| 21:39.07 | *** mode/#UPHPU [+o wps] by ChanServ |
| 21:58.45 | *** join/#uphpu wps (~wps@75-169-241-232.slkc.qwest.net) |
| 21:58.45 | *** mode/#UPHPU [+o wps] by ChanServ |
| 21:58.56 | *** join/#uphpu redroy (~Adium@67.137.120.26) |
| 22:43.08 | macnewbold | $chuck-fact |
| 22:43.09 | raifbot | Jack was nimble, Jack was quick, but Jack still couldn't dodge Chuck Norris' roundhouse kick. |
| 22:43.42 | josephscott | man, suppose to snow tonight |
| 22:45.40 | macnewbold | seriously? man i've had about enough of this. |
| 22:45.40 | jsmith | w00t! |
| 22:45.59 | mindjuju | shush you |
| 22:46.03 | macnewbold | me too, but in moderation from april to october |
| 22:46.19 | jsmith | It's 84 degrees outside right now here in Virginia |
| 22:46.50 | josephscott | $weather 84092 |
| 22:46.50 | raifbot | josephscott - current weather for 84092 - Cloudy 50f / 10c Humidity: 75% Wind: S at 6 mph |
| 22:48.04 | jsmith | $weather 22554 |
| 22:48.05 | raifbot | jsmith - current weather for 22554 - Partly Cloudy 87f / 31c Humidity: 58% Wind: S at 11 mph |
| 22:48.17 | jsmith | Oooh, 87 :-) |
| 22:48.24 | jsmith | (and lower humidity to boot!) |
| 22:50.05 | beandog | I think my brain has checked out for the day |
| 22:50.59 | josephscott | $lart jsmith's pleasant weather |
| 22:50.59 | raifbot | lowers jsmith's pleasant weather's priority. |
| 23:13.44 | josephscott | $chuck-fact |
| 23:13.45 | raifbot | The chief export of Chuck Norris is pain. |
| 23:13.59 | josephscott | $8ball will it really snow at my house tonight? |
| 23:13.59 | raifbot | josephscott - Without a doubt. |
| 23:15.34 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |