MYSQL 比较集

<span>    <span class="cm-operator">-> <span class="cm-variable">cc <span class="cm-variable">char(<span class="cm-number">10));</span></span></span></span></span>

<span><span class="cm-variable">insert <span class="cm-variable">into <span class="cm-variable">ss <span class="cm-variable">values (<span class="cm-atom">null,<span class="cm-string">"a");</span></span></span></span></span></span></span>

<span><span class="cm-variable">insert <span class="cm-variable">into <span class="cm-variable">ss <span class="cm-variable">values (<span class="cm-atom">null,<span class="cm-string">"A");</span></span></span></span></span></span></span>

<span><span class="cm-variable">insert <span class="cm-variable">into <span class="cm-variable">ss <span class="cm-variable">values (<span class="cm-atom">null,<span class="cm-string">"b");</span></span></span></span></span></span></span>

<span><span class="cm-variable">insert <span class="cm-variable">into <span class="cm-variable">ss <span class="cm-variable">values (<span class="cm-atom">null,<span class="cm-string">"B");</span></span></span></span></span></span></span>

<span><span class="cm-operator">-------------------------------------------------------------</span></span>

<span><span class="cm-variable">mysql<span class="cm-operator">> <span class="cm-variable">select <span class="cm-operator">* <span class="cm-variable">from <span class="cm-variable">ss <span class="cm-variable">order <span class="cm-variable">by <span class="cm-variable">cc <span class="cm-variable">asc;</span></span></span></span></span></span></span></span></span></span></span>

<span><span class="cm-operator">+----+------+</span></span>

<span><span class="cm-operator">| <span class="cm-variable">id <span class="cm-operator">| <span class="cm-variable">cc   <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">+----+------+</span></span>

<span><span class="cm-operator">|  <span class="cm-number">1 <span class="cm-operator">| <span class="cm-variable">a    <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">|  <span class="cm-number">2 <span class="cm-operator">| <span class="cm-variable">A    <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">|  <span class="cm-number">3 <span class="cm-operator">| <span class="cm-variable">b    <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">|  <span class="cm-number">4 <span class="cm-operator">| <span class="cm-variable">B    <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">+----+------+</span></span>

<span> <span class="cm-variable">mysql<span class="cm-operator">> <span class="cm-variable">select <span class="cm-operator">* <span class="cm-variable">from <span class="cm-variable">ss <span class="cm-variable">order <span class="cm-variable">by <span class="cm-variable">cc <span class="cm-variable">desc;</span></span></span></span></span></span></span></span></span></span></span>

<span><span class="cm-operator">+----+------+</span></span>

<span><span class="cm-operator">| <span class="cm-variable">id <span class="cm-operator">| <span class="cm-variable">cc   <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">+----+------+</span></span>

<span><span class="cm-operator">|  <span class="cm-number">3 <span class="cm-operator">| <span class="cm-variable">b    <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">|  <span class="cm-number">4 <span class="cm-operator">| <span class="cm-variable">B    <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">|  <span class="cm-number">1 <span class="cm-operator">| <span class="cm-variable">a    <span class="cm-operator">|</span></span></span></span></span></span>

<span><span class="cm-operator">|  <span class="cm-number">2 <span class="cm-operator">| <span class="cm-variable">A    <span class="cm-operator">|</span></span></span></span></span></span>

MYSQL 比较集

标签：prim   cti   dem   一个   key   字符集   rom   lin   mysq