<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                合規國際互聯網加速 OSASE為企業客戶提供高速穩定SD-WAN國際加速解決方案。 廣告
                **1. 語法** ```sql # 語法1 CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE # 語法2 CASE WHEN condition THEN statement_list [WHEN condition THEN statement_list] ... [ELSE statement_list] END CASE - case_value:當 case_value = when_value 時,執行 statement_list 語句 - condition:條件成立則執行 statement_list 語句 ``` **2. 演示** ```sql # 1. 準備演示數據 drop table if exists account; create table account ( `id` int(11) primary key auto_increment not null, `username` varchar(255) not null, `password` varchar(255) not null ); insert into account values(1, '張三', 'zhangsan'); insert into account values(2, '李四', 'lisi'); # 2. 在存儲過程中使用 case 語句 delimiter $ create procedure proce_account02(in id_ int, in uname varchar(255), in pass varchar(255)) begin case when id_ = 1 then update account set username=uname, password=pass; when id_ = 2 then delete from account where id=id_; else insert into account values(id_, uname, pass); end case; end $ # 3. 調用存儲過程 call proce_account02(3, '王五', 'wangwu') $ # 4. 查看結果 mysql> select * from account $ +----+----------+----------+ | id | username | password | +----+----------+----------+ | 1 | 張三 | zhangsan | | 2 | 李四 | lisi | | 3 | 王五 | wangwu | +----+----------+----------+ ``` **3. 在 select 語句中使用 case 語句** ```sql select case when id = 1 then 'one' when id = 2 then 'two' when id = 3 then 'three' end as result, id, username from account; +--------+----+----------+ | result | id | username | +--------+----+----------+ | one | 1 | 張三 | | two | 2 | 李四 | | three | 3 | 王五 | +--------+----+----------+ ```
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看