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--

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@gmail.com



2010/12/1 Mohan L

> 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--