List:General Discussion« Previous MessageNext Message »
From:HaidarPesebe Date:November 11 2010 9:40am
Subject:Re: backfill results for the same month and year
View as plain text  
I've tried it and succeeded. thanks mark

  ----- Original Message ----- 
  From: HaidarPesebe 
  To: MySQL Lists 
  Sent: Thursday, November 11, 2010 4:00 PM
  Subject: backfill results for the same month and year


  Dear All,

  I have the following data

  ID CITY      QTY   MONTH YEAR
  -------------------------------
  1  Chigago    10     11       2010
  1  NewYork   22     11       2010
  1  London     54     11       2010
  1  Chigago    7      10       2010
  1  NewYork   26     10       2010
  1  London     33     10       2010

  ID = ID PRODUCT.

  How can I backfill results with the same ID by month and year, with results like this:

  MONTH/YEAR    QTY TOTAL
  ---------------------------
  11/2010            86
  10/2010            66
  and etc.

  Please help

  Thanks
  haidarpesebe
Thread
• backfill results for the same month and yearHaidarPesebe11 Nov
  • Re: backfill results for the same month and yearMark Goodge11 Nov
• Re: backfill results for the same month and yearHaidarPesebe11 Nov