mysql 常用指令

If you want to change the table default character set and all character columns to a new character set, use a statement like this:

<code><span class="kwd">ALTER<span class="pln"> <span class="kwd">TABLE<span class="pln"> tbl_name <span class="kwd">CONVERT<span class="pln"> <span class="kwd">TO<span class="pln"> CHARACTER <span class="kwd">SET<span class="pln"> charset_name<span class="pun">;</span></span></span></span></span></span></span></span></span></span></span></code>

So query will be:

<code><span class="kwd">ALTER<span class="pln"> <span class="kwd">TABLE<span class="pln"> etape_prospection <span class="kwd">CONVERT<span class="pln"> <span class="kwd">TO<span class="pln"> CHARACTER <span class="kwd">SET<span class="pln"> utf8<span class="pun">;</span></span></span></span></span></span></span></span></span></span></span></code>

mysql 常用指令

标签：name   class   this   bsp   useful   har   set   accept   change