<p><br></p><p>임시테이블 사용방법이 가끔 헷갈리는데 아래와 같이 사용하면 된다.</p><p><br></p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div>#&nbsp;임시테이블&nbsp;있으면&nbsp;삭제</div><div><span style="color: #569cd6;">DROP</span>&nbsp;TEMPORARY&nbsp;<span style="color: #569cd6;">TABLE</span>&nbsp;<span style="color: #569cd6;">IF</span>&nbsp;<span style="color: #569cd6;">EXISTS</span>&nbsp;tmp_table;</div><br><div>#&nbsp;조회하면서&nbsp;임시테이블&nbsp;만들어서&nbsp;넣기</div><div><span style="color: #569cd6;">CREATE</span>&nbsp;TEMPORARY&nbsp;<span style="color: #569cd6;">TABLE</span>&nbsp;tmp_table&nbsp;</div><div><span style="color: #569cd6;">SELECT</span>&nbsp;*&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;tbl_table <span style="color: #569cd6;">LIMIT</span>&nbsp;<span style="color: #b5cea8;">10</span>;</div><br><div>#&nbsp;임시테이블&nbsp;조회</div><div><span style="color: #569cd6;">SELECT</span>&nbsp;*&nbsp;<span style="color: #569cd6;">FROM</span>&nbsp;tmp_table;</div></div><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>

[MySQL & MariaDB] 임시테이블 사용 방법