| --- Log opened Fri May 19 00:00:13 2017 |
| 00:24 | | Jessikat`` [Jessikat@Nightstar-kdoqer.dab.02.net] has quit [[NS] Quit: Bye] |
| 00:32 | | himi-cat [sjjf@Nightstar-dm0.2ni.203.150.IP] has joined #code |
| 00:32 | | mode/#code [+o himi-cat] by ChanServ |
| 00:36 | | celmin|sleep is now known as celticminstrel |
| 01:05 | | Jessikat` [Jessica@Nightstar-bt5k4h.81.in-addr.arpa] has quit [[NS] Quit: Leaving] |
| 01:15 | | Jessikat [Jessikat@Nightstar-vpqrrl.dab.02.net] has joined #code |
| 03:04 | | Turaiel[Offline] is now known as Turaiel |
| 03:28 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has quit [A TLS packet with unexpected length was received.] |
| 04:51 | | Turaiel is now known as Turaiel[Offline] |
| 05:29 | | celticminstrel is now known as celmin|sleep |
| 06:31 | | himi-cat [sjjf@Nightstar-dm0.2ni.203.150.IP] has quit [Ping timeout: 121 seconds] |
| 06:36 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 06:45 | | Alek [Alek@Nightstar-7or629.il.comcast.net] has quit [Ping timeout: 121 seconds] |
| 06:46 | | ion [Owner@Nightstar-gmbj85.vs.shawcable.net] has quit [Ping timeout: 121 seconds] |
| 06:47 | | Kindamoody[zZz] is now known as Kindamoody |
| 06:48 | | Alek [Alek@Nightstar-7or629.il.comcast.net] has joined #code |
| 06:48 | | mode/#code [+o Alek] by ChanServ |
| 07:18 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 07:18 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 07:24 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 07:25 | | Jessikat` [Jessikat@Nightstar-cr2itg.dab.02.net] has joined #code |
| 07:27 | | Kindamoody is now known as Kindamoody|afk |
| 07:28 | | Jessikat [Jessikat@Nightstar-vpqrrl.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 08:00 | | Jessikat [Jessikat@Nightstar-cr2itg.dab.02.net] has joined #code |
| 08:00 | | Jessikat` [Jessikat@Nightstar-cr2itg.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
| 08:14 | | macdjord|fude is now known as macdjord|slep |
| 08:25 | | himi-cat [sjjf@Nightstar-v37cpe.internode.on.net] has joined #code |
| 08:25 | | mode/#code [+o himi-cat] by ChanServ |
| 10:00 | < sshine> | I've got "SELECT domain, COUNT(domain) AS count FROM emails WHERE ... GROUP BY domain ORDER BY count DESC" and I'd like to have a separate row that summarizes the count without having to repeat the 'WHERE ...'. if I use SUM(), that collapses the rows. if I use UNION, I have to repeat the WHERE clause. |
| 10:00 | < sshine> | any ideas? |
| 10:09 | <@himi-cat> | I don't think sql supports that kind of thing |
| 11:10 | < sshine> | himi-cat, 'GROUP BY ... WITH ROLLUP'! |
| 11:10 | <@himi-cat> | Huh |
| 11:10 | < sshine> | https://dev.mysql.com/doc/refman/5.7/en/group-by-modifiers.html |
| 11:10 | <@himi-cat> | Is that standard, or an extension? |
| 11:11 | < sshine> | probably an extension. but it exists in both MySQL and MSSQL. |
| 13:55 | | Jessikat` [Jessikat@Nightstar-i60ktm.dab.02.net] has joined #code |
| 13:57 | | Jessikat [Jessikat@Nightstar-cr2itg.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 14:14 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 14:14 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 14:54 | | Jessikat` is now known as Jessikat |
| 18:11 | | Jessikat` [Jessica@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 20:25 | | Jessikat`` [Jessikat@Nightstar-m8o.tcr.132.82.IP] has joined #code |
| 20:27 | | Jessikat [Jessikat@Nightstar-i60ktm.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 20:35 | | RchrdB [RchrdB@Nightstar-qe9.aug.187.81.IP] has joined #code |
| 21:37 | | Kindamoody|afk is now known as Kindamoody |
| 22:11 | | Jessikat`` [Jessikat@Nightstar-m8o.tcr.132.82.IP] has quit [Ping timeout: 121 seconds] |
| 22:50 | | RchrdB [RchrdB@Nightstar-qe9.aug.187.81.IP] has quit [Operation timed out] |
| 23:19 | | Kindamoody is now known as Kindamoody[zZz] |
| --- Log closed Sat May 20 00:00:14 2017 |