<p align="left">안녕하세요.</p> <p>회사에서 간단히 DB 서버를 구성하여 공장에서 생산 공정을 관리하고 있습니다.</p> <p>DB 는 MariaDB 사용 중입니다.</p> <p>아래는 그 예이고 박스별 각 공정을 진행한 날짜를 입력했는데요.<font size="3"> </font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"> </font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"> </font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"> </font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"></font><font size="3"> </font></p> <table width="339" style="width:255pt;border-collapse:collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="72" style="width:54pt;"></colgroup><colgroup><col width="89" style="width:67pt;" span="3"></colgroup><tbody><tr height="22" style="height:16.5pt;"><td width="72" height="22" style="border:.5pt solid;width:54pt;height:16.5pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">box_no</font></p></td> <td width="89" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;border-color:#000000;width:67pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">process_1</font></p></td> <td width="89" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;border-color:#000000;width:67pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">process_2</font></p></td> <td width="89" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;border-color:#000000;width:67pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">process_3</font></p></td></tr><tr height="22" style="height:16.5pt;"><td height="22" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">1</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-16</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-16</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-17</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">2</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-16</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-16</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-18</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">3</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-16</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-17</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-19</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">4</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-17</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-17</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-19</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">5</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-17</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-17</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p><br></p></td></tr></tbody></table><p><br></p> <p>각 공정의 날짜별 진행 갯수는 아래와 같이 group by 를 써서 살펴보고 있습니다.</p> <p>select process_1, count(process_1) from product group by process_1 ;</p> <p><br></p> <p>그런데 이걸 아래와 같이 컬럼별 진행 갯수를 날짜 기준으로 표시하려 합니다.</p><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font> <table width="356" style="width:268pt;border-collapse:collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="89" style="width:67pt;" span="4"></colgroup><tbody><tr height="22" style="height:16.5pt;"><td width="89" height="22" style="border:.5pt solid;width:67pt;height:16.5pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">date</font></p></td> <td width="89" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;border-color:#000000;width:67pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">process_1</font></p></td> <td width="89" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;border-color:#000000;width:67pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">process_2</font></p></td> <td width="89" style="border-width:.5pt .5pt .5pt 0px;border-style:solid solid solid none;border-color:#000000;width:67pt;background-color:#ffff00;"> <p align="center"><font face="맑은 고딕" size="3">process_3</font></p></td></tr><tr height="22" style="height:16.5pt;"><td height="22" align="right" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-16</font></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">3</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">2</font></p></td> <td align="right" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">0</font></p></td></tr><tr height="22" style="height:16.5pt;"><td height="22" align="right" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-17</font></td> <td align="right" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">2</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">3</font></p></td> <td align="right" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">1</font></p></td></tr><tr height="22" style="height:16.5pt;"><td height="22" align="right" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-18</font></td> <td align="right" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">0</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">0</font></p></td> <td align="right" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">1</font></p></td></tr><tr height="22" style="height:16.5pt;"><td height="22" align="right" style="border-width:0px .5pt .5pt;border-style:none solid solid;border-color:#000000;height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">2019-07-19</font></td> <td align="right" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">0</font></p></td> <td style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">0</font></p></td> <td align="right" style="border-width:0px .5pt .5pt 0px;border-style:none solid solid none;border-color:#000000;background-color:transparent;"> <p align="center"><font face="맑은 고딕" size="3">2</font></p></td></tr></tbody></table><p><br></p> <p>이래저래 검색해 봐도 잘 나오지 않아 질문 드립니다.</p> <p>답변이나 힌트라도 주시면 고맙겠습니다.</p> <p><br></p>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.