17.10.2009 2:19, Terry L. Inzauro kirjoitti:
For testing, I've decided to use the mysql command line interface and I have one last question. How would I take take sums of two columns such as JobFiles and JobBytes [18:13:04 r...@jenna:~]# mysql -u root -pxxxxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 489 Server version: 5.0.51a-24+lenny2-log (Debian) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use bacula; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT DISTINCT Job.JobId as JobId,Client.Name as Client, FileSet.FileSet AS FileSet,Level,StartTime, JobFiles,JobBytes,VolumeName FROM Client,Job,JobMedia,Media,FileSet WHERE Client.Name='peyton' AND Client.ClientId=Job.ClientId AND Job.Type='B' AND Job.JobStatus='T' AND Job.FileSetId=FileSet.FileSetId AND JobMedia.JobId=Job.JobId AND JobMedia.MediaId=Media.MediaId ORDER BY Job.StartTime; +-------+--------+---------------+-------+---------------------+----------+-----------+---------------+ | JobId | Client | FileSet | Level | StartTime | JobFiles | JobBytes | VolumeName | +-------+--------+---------------+-------+---------------------+----------+-----------+---------------+ | 4700 | peyton | StandardLinux | F | 2009-09-06 05:28:54 | 47498 | 789899195 | FullPool_0067 | | 4777 | peyton | StandardLinux | D | 2009-09-13 00:37:11 | 50 | 2442702 | DiffPool_0004 | | 4910 | peyton | StandardLinux | I | 2009-09-25 00:28:57 | 43 | 2095221 | IncrPool_0036 | | 4921 | peyton | StandardLinux | I | 2009-09-26 00:29:15 | 41 | 2072585 | IncrPool_0090 | | 4932 | peyton | StandardLinux | D | 2009-09-27 00:53:34 | 52 | 2497277 | DiffPool_0011 | | 4943 | peyton | StandardLinux | I | 2009-09-28 00:29:48 | 50 | 2366865 | IncrPool_0037 | | 4954 | peyton | StandardLinux | I | 2009-09-29 00:28:55 | 41 | 2018132 | IncrPool_0119 | | 4965 | peyton | StandardLinux | I | 2009-09-30 00:38:28 | 41 | 2035566 | IncrPool_0136 | | 4976 | peyton | StandardLinux | I | 2009-10-01 00:29:36 | 41 | 2052047 | IncrPool_0130 | | 4987 | peyton | StandardLinux | I | 2009-10-02 00:31:56 | 45 | 2069134 | IncrPool_0011 | | 4998 | peyton | StandardLinux | I | 2009-10-03 00:29:48 | 41 | 2085954 | IncrPool_0140 | | 5009 | peyton | StandardLinux | F | 2009-10-04 05:36:39 | 47498 | 789930570 | FullPool_0009 | | 5020 | peyton | StandardLinux | I | 2009-10-05 00:29:15 | 50 | 2378897 | IncrPool_0029 | | 5031 | peyton | StandardLinux | I | 2009-10-06 00:29:07 | 41 | 2029220 | IncrPool_0004 | | 5042 | peyton | StandardLinux | I | 2009-10-07 00:51:50 | 41 | 2046245 | IncrPool_0055 | | 5053 | peyton | StandardLinux | I | 2009-10-08 00:28:28 | 41 | 2062919 | IncrPool_0077 | | 5108 | peyton | StandardLinux | I | 2009-10-14 01:25:39 | 50 | 2430892 | IncrPool_0079 | | 5119 | peyton | StandardLinux | I | 2009-10-14 02:41:33 | 50 | 2431747 | IncrPool_0027 | | 5130 | peyton | StandardLinux | I | 2009-10-15 00:30:11 | 41 | 2073822 | IncrPool_0009 | | 5141 | peyton | StandardLinux | I | 2009-10-16 00:30:07 | 41 | 2091084 | IncrPool_0005 | +-------+--------+---------------+-------+---------------------+----------+-----------+---------------+ 20 rows in set (0.01 sec)
If you want that same list, and add the sums at the end, I don't believe it is possible with MySQL client. It would be easy with Oracle SQL*Plus, but not with MySQL client. A simple query will return those SELECT SUM(JobFiles) AS JobFilesSum, SUM(JobBytes) AS JobBytesSum FROM Job ; but that is not much of interest, I guess. -- http://www.iki.fi/jarif/ Ships are safe in harbor, but they were never meant to stay there.
pgp4nr7VIFAt3.pgp
Description: PGP signature
------------------------------------------------------------------------------ Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference
_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users