Jari Fredriksson wrote:
> 18.10.2009 0:32, Markus Falb kirjoitti:
>> Terry L. Inzauro wrote:
>>
>>> 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
>>
>> Use the addition
18.10.2009 0:32, Markus Falb kirjoitti:
Terry L. Inzauro wrote:
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
Use the addition Operator like that:
mysql> select JobFile
Terry L. Inzauro wrote:
> 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
Use the addition Operator like that:
mysql> select JobFiles+JobBytes from Job where JobFiles > 0 li
17.10.2009 17:41, Terry L. Inzauro kirjoitti:
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 t
Jari Fredriksson wrote:
>
>
> 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 ro
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 -px
Welcome to the MySQL monitor. C
John Drescher wrote:
> On Fri, Oct 16, 2009 at 6:30 PM, Terry L. Inzauro
> wrote:
>> John Drescher wrote:
>>> On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro
>>> wrote:
Does bconsole support sorting of output? For instance, can bconsole sort
the output of "list volumes pool=FullPoo
On Fri, Oct 16, 2009 at 6:30 PM, Terry L. Inzauro
wrote:
> John Drescher wrote:
>> On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro
>> wrote:
>>> Does bconsole support sorting of output? For instance, can bconsole sort
>>> the output of "list volumes pool=FullPool" by size
>>> or date?
>>>
>>
John Drescher wrote:
> On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro
> wrote:
>> Does bconsole support sorting of output? For instance, can bconsole sort
>> the output of "list volumes pool=FullPool" by size
>> or date?
>>
>> kind regards,
>>
>
> You can do that in a query.
>
> John
Wh
Hi:
On Fri, Oct 16, 2009 at 4:03 PM, Terry L. Inzauro
wrote:
> Does bconsole support sorting of output? For instance, can bconsole sort
> the output of "list volumes pool=FullPool" by size
> or date?
>
I don't think this is possible but you could some bash script to sort:
-init of bconsol
On Fri, Oct 16, 2009 at 5:03 PM, Terry L. Inzauro
wrote:
> Does bconsole support sorting of output? For instance, can bconsole sort
> the output of "list volumes pool=FullPool" by size
> or date?
>
> kind regards,
>
You can do that in a query.
John
---
Does bconsole support sorting of output? For instance, can bconsole sort the
output of "list volumes pool=FullPool" by size
or date?
kind regards,
Terry
--
Come build with us! The BlackBerry(R) Developer Conference
12 matches
Mail list logo
