mysql - SQL loop with data aggregation -

-

इस सवाल का पहले से ही एक उत्तर है: < / p>

  • 8 जवाब

    मैं MySQL 5.5 का उपयोग कर रहा हूँ .38 और निम्न तालिका मिली (यह सिर्फ एक स्निपेट है, वास्तविक में ~ 500 उत्पाद हैं): 

      + ------ + ------- + - -------- + ------- + -------- + | आईडी | तिथि | उत्पाद | प्रकार | बिक्री | + ------ + ------- + ---------- + ------- + -------- + | 4513 | 14958 | XXXXXXX | 1 | 3 | | 4514 | 14958 | XXXXXXX | 2 | 5 | | 4519 | 14958 | YYYYYYY | 1 | 10 | | 4531 | 14958 | YYYYYYY | 3 | 150 | | 4534 | 14 9 559 | ZZZZZZZ | 1 | 5 | | 4536 | 14 9 559 | ZZZZZZZ | 2 | 5 | | + ------ + ------- + ---------- + ------- + -------- +  < / प्री> 
     जिससे मुझे उत्पाद द्वारा दैनिक बिक्री की मात्रा उत्पन्न करने की आवश्यकता है:  
      + ------- + ---------- + - -------- + ---------- + | तिथि | XXXXXXX | YYYYYYY | ZZZZZZZ | + ------- + ---------- + ---------- + ---------- + | 14958 | 8 | 110 | 0 | + ------- + ---------- + ---------- + ---------- + | 14 9 559 | 0 | 0 | 10 | | + ------ + ---------- + ---------- + ---------- +   
     परिणाम तालिका को ऊपर की तरह दिखना है - स्तंभों और पंक्ति के दिनों में उत्पादों के साथ।  
     बस कुछ बिंदुओं की तलाश करते हुए, कार्य समाधान नहीं। धन्यवाद, पावेल।   
     
     
     गतिशील एकत्रीकरण के लिए,  
      SET @sql = NULL; चुनें GROUP_CONCAT (अलग कंकाट ('SUM (मामले जब उत्पाद = एक' 'उत्पाद, एक' 'तब एक विक्रय होगा, एक उत्पाद)), मेरे @table से @ sql में; SET @sql = CONCAT ('SELECT date,', @sql, 'my_table ग्रुप बाय डेट'); एसएसएमएएम से एसटीएमटी तैयार करें; EXTUTE STMT; डेलॉलिकेट तैयार करें STMT;   
     सशर्त  केस  का उपयोग करके  समूह  के साथ (स्थिर के लिए)  
      SELECT s.date, एसएम (मामला जब एस। प्रोडक्ट = 'एक्स XXXXXXX' तो एस एसएसएलएसई ELSE 0 END) एएस 'XXXXXXX' के रूप में, एसएम (मामला जब एस। प्रोडक्ट = 'वाई वाई य्यय्याय' तो एसएसएसएलएसई ELSE 0 एडीडी) एएस 'वाई वाई य्याय्याय', एसएम ( मामले में जब s.product = 'ZZZZZZ' तो एस एसएसएलएसई ELSE 0 END) के रूप में 'ZZZZZZZ' से my_table एस ग्रुप द्वारा s.date;

Comments

Post a Comment

Popular posts from this blog

php - PDO bindParam() fatal error -

-
I am trying to learn PDO, now I have written this small code, but it gives me a serious error: Fatal error: Call a member function at a non-object dot () ... $ con = new mysqli ("127.0.0.1", "root", "", "csvdangercheck"); $ Query = $ con- & gt; ("Id,` var1`, `var2`) values ​​(" id,: var1,: var2) ";); $ query- & gt; bypass pattern (': id', $ id); $ query- & gt; BindParam (': var1', $ VAL1); $ Query- & gt; bindParam (': var2', $ val2); $ Query-> Executed (); I Trying to use print_r ($ con-> errorInfo ()) but Fatal error: Undefined method mysqli :: errorInfo ( ) ... can someone tell me what am I missing? Flaffeh said, you have PDO Missing Mysqy, try it: $ con = new PDO ('mysql: host = 127.0.0.1; dbname = csvdangercheck', 'root', '');
Read more

php - How can I cram 6+31 numeric characters into 22 alphanumeric characters? -

-
I have a 6 digit number and a 31-digit number (such as "234536" and "201103231043330478311223582826") that I The API needs to be crawled in the same 22-character alphanumeric field that uses PHP. I tried to convert each one to 32 (using custom code could not handle the base_convert () large number) and to connect with a single-character delimiter, but It only gives me 26 characters This is a restore API, so the letters should be URI-protected. I would like to do a database table cross with two references without reference to another reference value, if possible, any suggestions? Instead use a radix of 62. This will give you 22 characters for the top, 3.35 for the pre and 17.3 for the next. & gt; & Gt; & Gt; Math.log (10 ** 6) /math.log (62) 3.3474826039165504 & gt; & Gt; & Gt; Math.log (10 ** 31) /math.log (62) 17.295326786902177
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more