sub query to daily usage subtraction

--001485e7e940f48202049648feb0
Content-Type: text/plain; charset=ISO-8859-1

Dear All,

My Mysql Table contain 5 column id,data,storage,bandwidth_sent,
bandwidth_received , like this : http://pastebin.com/ghXWMZ7V. The storage
and bandwidth information is accumulated one. I need to fetch my daily usage
from data bases. I need to subtract today's storage -yesterday storage
bases on date .Here id is same. I am new to witting mysql query (learning).
I think this can be done using sub query. any help will be really
appreciated .

Thanks & Rg
Mohan L

--001485e7e940f48202049648feb0--
Mohan L [ Di, 30 November 2010 19:02 ] [ ID #2051044 ]

Re: sub query to daily usage subtraction

--0023547c9be1cc9d7b0498235539
Content-Type: text/plain; charset=UTF-8

Hi,
I'm confusion with your issue. Can you show us your detailed wanted?
David Yeung, In China, Beijing.
My First Blog:http://yueliangdao0608.cublog.cn
My Second Blog:http://yueliangdao0608.blog.51cto.com
My Msn: yueliangdao0608 [at] gmail.com



2010/12/1 Mohan L <l.mohanphy [at] gmail.com>

> Dear All,
>
> My Mysql Table contain 5 column id,data,storage,bandwidth_sent,
> bandwidth_received , like this : http://pastebin.com/ghXWMZ7V. The
> storage
> and bandwidth information is accumulated one. I need to fetch my daily
> usage
> from data bases. I need to subtract today's storage -yesterday storage
> bases on date .Here id is same. I am new to witting mysql query (learning).
> I think this can be done using sub query. any help will be really
> appreciated .
>
> Thanks & Rg
> Mohan L
>

--0023547c9be1cc9d7b0498235539--
david.yang [ Fr, 24 Dezember 2010 08:57 ] [ ID #2052032 ]
Datenbanken » gmane.comp.db.mysql.general » sub query to daily usage subtraction

Vorheriges Thema: ANN: Database Workbench 4.1.0, the multi-DBMS IDE now available!
Nächstes Thema: Table cache not being updated