카테고리 table <div><br></div> <div><table border="0" cellpadding="0" cellspacing="0" width="342" style="border-collapse:collapse;width:256pt;"><colgroup><col width="59" style="width:44pt;"><col width="84" style="width:63pt;"><col width="112" style="width:84pt;"><col width="87" style="width:65pt;"></colgroup><tbody><tr height="22" style="height:16.5pt;"><td height="22" class="xl66" width="59" style="height:16.5pt;width:44pt;">cate_id</td> <td class="xl66" width="84" style="border-left-style:none;width:63pt;">cate_name</td> <td class="xl66" width="112" style="border-left-style:none;width:84pt;">cate_parent_id</td> <td class="xl66" width="87" style="border-left-style:none;width:65pt;">cate_depth</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">1</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">a</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">1</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">1</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">2</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">b</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">2</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">1</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">3</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">c</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">1</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">2</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">4</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">d</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">5</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">e</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">1</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">2</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">6</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">f</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">7</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">g</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">8</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">h</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">3</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">9</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">i</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">7</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">4</td> </tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl65" style="height:16.5pt;border-top-style:none;">10</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">j</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">7</td> <td class="xl65" style="border-top-style:none;border-left-style:none;">4</td> </tr></tbody></table><br></div> <div>최고 부모 id를 찾는 쿼리를 만들고 싶습니다.</div> <div>db는 mysql이구요.</div> <div><br></div> <div>예를들어 cate_id가 9의 최고 부모를 찾고 싶다면</div> <div>parent_id인 7을 찾아가서 7의부모 3, 그리고 3의 부모 1을 찾아야되염.</div> <div>그리고 최고 부모인 1이 cate_depth가 1인것을 확인하면 되겠죠.</div> <div><br></div> <div>키 cate_id 만으로 찾을 수 있나요?</div> <div><br></div>
난 차이기 전에 사귀자고 말하는 징크스가 있어
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.