<![CDATA[<span class="pln">
</span><span class="tag"><script</span><span class="pln"> </span><span class="atn">src</span><span class="pun">=</span><span class="atv">"https://cdn.jsdelivr.net/gh/google/code-prettify@master/loader/run_prettify.js"</span><span class="tag">></script></span><span class="pln">
</span><span class="tag"><h2></span><span class="pln">$builder->delete()</span><span class="tag"></h2></span><span class="pln">
</span><span class="tag"><p></span><span class="pln">
DELETE SQL을 생성하고 쿼리를 실행합니다.
</span><span class="tag"></p></span><span class="pln">
</span><span class="tag"><pre</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"prettyprint"</span><span class="tag">></span><span class="pln">
$builder->delete(['idx' => 1]);
</span><span class="pun"><?=</span><span class="pln"> print_r</span><span class="pun">(</span><span class="pln">$builder</span><span class="pun">-></span><span class="kwd">delete</span><span class="pun">([</span><span class="str">'idx'</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="lit">1</span><span class="pun">]),</span><span class="pln"> </span><span class="kwd">true</span><span class="pun">)</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="pun"><?=</span><span class="pln"> get_last_query</span><span class="pun">()</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="tag"></pre></span><span class="pln">
</span><span class="tag"><p></span><span class="pln">
첫 번째 매개 변수는 where절입니다. 함수의 첫 번째 매개 변수에 데이터를 전달하는 대신 `where()`나 `or_where()` 함수를 사용할 수 있습니다.</span><span class="tag"><br/></span><span class="pln">
테이블에서 모든 데이터를 삭제하려면 `truncate()` 함수 또는 `emptyTable()` 함수를 사용합니다.
</span><span class="tag"></p></span><span class="pln">
</span><span class="tag"><pre</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"prettyprint"</span><span class="tag">></span><span class="pln">
$builder->where(['idx' => 1])->delete();
</span><span class="pun"><?=</span><span class="pln"> print_r</span><span class="pun">(</span><span class="pln">$builder</span><span class="pun">-></span><span class="kwd">where</span><span class="pun">([</span><span class="str">'idx'</span><span class="pln"> </span><span class="pun">=></span><span class="pln"> </span><span class="lit">1</span><span class="pun">])-></span><span class="kwd">delete</span><span class="pun">(),</span><span class="pln"> </span><span class="kwd">true</span><span class="pun">)</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="pun"><?=</span><span class="pln"> get_last_query</span><span class="pun">()</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="tag"></pre></span><span class="pln">
</span><span class="tag"><h2></span><span class="pln">$builder->emptyTable()</span><span class="tag"></h2></span><span class="pln">
</span><span class="tag"><p></span><span class="pln">
DELETE SQL을 생성하고 쿼리를 실행합니다.
</span><span class="tag"></p></span><span class="pln">
</span><span class="tag"><pre</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"prettyprint"</span><span class="tag">></span><span class="pln">
$builder->emptyTable();
</span><span class="pun"><?=</span><span class="pln"> print_r</span><span class="pun">(</span><span class="pln">$builder</span><span class="pun">-></span><span class="pln">emptyTable</span><span class="pun">(),</span><span class="pln"> </span><span class="kwd">true</span><span class="pun">)</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="pun"><?=</span><span class="pln"> get_last_query</span><span class="pun">()</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="tag"></pre></span><span class="pln">
</span><span class="tag"><h2></span><span class="pln">$builder->truncate()</span><span class="tag"></h2></span><span class="pln">
</span><span class="tag"><p></span><span class="pln">
TRUNCATE SQL을 생성하고 쿼리를 실행합니다.
</span><span class="tag"></p></span><span class="pln">
</span><span class="tag"><pre</span><span class="pln"> </span><span class="atn">class</span><span class="pun">=</span><span class="atv">"prettyprint"</span><span class="tag">></span><span class="pln">
$builder->truncate();
</span><span class="pun"><?=</span><span class="pln"> print_r</span><span class="pun">(</span><span class="pln">$builder</span><span class="pun">-></span><span class="pln">truncate</span><span class="pun">(),</span><span class="pln"> </span><span class="kwd">true</span><span class="pun">)</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="pun"><?=</span><span class="pln"> get_last_query</span><span class="pun">()</span><span class="pln"> </span><span class="pun">?></span><span class="pln">
</span><span class="tag"></pre></span>]]>