<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國際加速解決方案。 廣告
                # 數據庫 \['between', 'id', 1, 10\] 將會生成 id BETWEEN 1 AND 10~~~ 查詢多條 $posts = Yii::$app->db->createCommand('SELECT \* FROM post') ->queryAll(); 查詢一條 $post = Yii::$app->db->createCommand('SELECT \* FROM post WHERE id=1')->queryOne(); 返回一列 $titles = Yii::$app->db->createCommand('SELECT title FROM post') ->queryColumn(); 返回標量 $count = Yii::$app->db->createCommand('SELECT COUNT(\*) FROM post') ->queryScalar(); 綁定參數 $post = Yii::$app->db->createCommand('SELECT \* FROM post WHERE id=:id AND status=:status') ->bindValue(':id', $\_GET\['id'\]) ->bindValue(':status', 1) ->queryOne(); 非查詢 Yii::$app->db->createCommand('UPDATE post SET status=1 WHERE id=1') ->execute(); Yii::$app->db->createCommand()->insert('user', \[ 'name' => 'Sam', 'age' => 30, \])->execute(); Yii::$app->db->createCommand()->update('user', \['status' => 1\], 'age > 30')->execute(); Yii::$app->db->createCommand()->delete('user', 'status = 0')->execute(); ``` <pre class="calibre14">``` 生成器 ``` ``` $query->select(\['id', 'email'\]); $subQuery = (new Query())->select('COUNT(\*)')->from('user'); $query->select('user\_id')->distinct();//去重復 $query->from(\['u' => 'public.user', 'p' => 'public.post'\]);多表 $query->where('status=:status', \[':status' => $status\]); $query->where('status=1'); $query->where(\[ 'status' => 10, 'type' => null, 'id' => \[4, 8, 15\], \]); \['and', 'id=1', 'id=2'\] \['or', 'id=1', 'id=2'\] \['between', 'id', 1, 10\] 將會生成 id BETWEEN 1 AND 10 \['in', 'id', \[1, 2, 3\]\] 將生成 id IN (1, 2, 3) \['like', 'name', 'tester'\] 會生成 name LIKE '%tester%' \['>', 'age', 10\] 將會生成 age>10 $query->orderBy('id ASC, name DESC'); $query->groupBy('id, status'); $query->limit(10)->offset(20); // ... LEFT JOIN `post` ON `post`.`user_id` = `user`.`id` $query->join('LEFT JOIN', 'post', 'post.user\_id = [user.id](http://user.id)'); all():將返回一個由行組成的數組,每一行是一個由名稱和值構成的關聯數組(譯者注:省略鍵的數組稱為索引數組)。 one():返回結果集的第一行。 column():返回結果集的第一列。 scalar():返回結果集的第一行第一列的標量值。 exists():返回一個表示該查詢是否包結果集的值。 count():返回 COUNT 查詢的結果 ``` <pre class="calibre16">``` ``` ```
                  <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>

                              哎呀哎呀视频在线观看