This is more of an essay than a blog post, but this subject comes up time and again, and since I tripped across this interesting blog post by Pedro Timóteo about why he has decided not to be a sysadmin any more, I thought now’s as good a time as any to comment on what [...]
Just when we thought it couldn?t get any simpler for
organizations than downloading a pre-packaged messaging and
collaboration solution like Zimbra, Red Hat?s RHX program finds a way. The Zimbra team
is excited to participate in Red Hat?s RHX program. Zimbra?s
open
source community members have often asked if they could
download & evaluate, procure and get support for both the Red Hat
infrastructure and Zimbra?s rich Ajax-based messaging and
collaboration solution ? all online and from a single source. The
RHX program fulfills the community?s wishes by providing a
pre-integrated and Red Hat certified Zimbra solution for RHEL.
Zimbra is among the charter members of RHX along with other open
source market leaders like …
Red Hat Exchange went live minutes ago. We at Zmanda are thrilled to be one of the RHX launch partners: Alfresco, CentricCRM, Compiere, EnterpriseDB, Groundwork, Jaspersoft, Jive, MySQL, Pentaho, Scalix, SugarCRM, Zenoss, Zimbra and Zmanda. Congratulations to Matt Mattox and rest of RHX team at Red Hat.
Just noticed YouTube is down. Anyone else experiencing this?
In many cases you don't want your the result from your SQL
statement in just a plain listing, but organized in columns, or
whith data grouped on status, period or whatever. This can often
be accomplished with a combination of the IF function and SUM or
another group function.
For example get your sales per customer grouped by period:
SELECT customer_no AS CUSTNO, cust_name AS CUSTNAME,
sum(if(period = '200701',amount,0) as Jan_Amount,
sum(if(period = '200702',amount,0) as Jan_Amount
FROM otd.salestrans_hist s
WHERE period IN ('200701','200702')
GROUP BY customer_no, cust_name
Or number of open and closed records in each class:
SELECT class, sum(if(status='Open',1,0)) as open,
sum(if(status='Closed',1,0)) as closed
FROM table_name
GROUP BY class
In the examples I have used the MySQL IF function. You could also
use CASE, which is SQL …
I've learned how to write MySQL UDF's (User Defined Functions).
The interface isn't terrible complicated, tho it's annoying and
incomplete in many ways.
I'm going to use the UDF mechanism to shoehorn my AgentX SNMP
subagent into 4.0, 4.1, and 5.0, since they don't have the daemon
plugin interface that 5.1 has.
But now that I know how to write UDFs, what functions have you
always wished you could call from SQL?
Last thursday I got ticked at some Ruby docs, so I tried my hand
at C instead.
Just now:
$ wc -l toast.c
598 toast.c
$ git log --pretty=oneline | wc -l
24
$ cat build
#!/bin/bash
rm -f toast
gcc -g -Wall -Wextra -Wno-unused-parameter -O2 -o toast toast.c
-levent -llua
("toast" is localhost:5500, mysqld is localhost:3306)
MySQL Client
$ mysql -u root -h 127.0.0.1 -P 5500 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 62 Server version: 5.0.37 MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> \s -------------- mysql Ver 14.12 Distrib 5.0.38, for pc-linux-gnu (x86_64) using readline 5.1 Connection id: 62 Current database: Current user: root@localhost SSL: Not in …[Read more]
I take the easy way out again this week by sharing Guy Kawasaki (of the How To Change the World blog) and his irreverent and truthful keynote at the 2007 MySQL Users Conference.
Kawasaki will challenge your thoughts about being an entrepreneur in the technology industry.
The big news is that soon I’ll be able to announce that the videos from the conference sessions are up….stay tuned!
Show Notes:
Guy Kawasaki’s Blog: How to Change the World
http://blog.guykawasaki.com/
Direct play this episode at:
http://tinyurl.com/2h2d7j
Download all podcasts at:
http://technocation.org/podcasts/oursql/
Subscribe to the podcast at:
…