<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>

                文章表tp_article ~~~ CREATE TABLE `tp_article` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章ID', `cid` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT '分類ID', `title` varchar(255) NOT NULL DEFAULT '' COMMENT '標題', `content` longtext COMMENT '內容', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='文章表'; ~~~ 文章分類表tp_cate ~~~ CREATE TABLE `tp_cate` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '分類ID', `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上級分類ID', `name` varchar(50) NOT NULL COMMENT '分類名稱', signed NOT NULL DEFAULT '0' COMMENT '排序', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) USING BTREE ) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='分類表'; ~~~ 查詢語句總結 1.JOIN查詢 * INNER JOIN: 等同于 JOIN(默認的JOIN類型),如果表中有至少一個匹配,則返回行 * LEFT JOIN: 即使右表中沒有匹配,也從左表返回所有的行 * RIGHT JOIN: 即使左表中沒有匹配,也從右表返回所有的行 * FULL JOIN: 只要其中一個表中存在匹配,就返回行 ~~~ $resul=Db::table('tp_Article') ->join('tp_cate', 'tp_article.cid=tp_cate.id') ->select(); //完整sql語句 SELECT * FROM `tp_Article` INNER JOIN `tp_cate` ON `tp_Article`.`cid`=`tp_cate`.`id` ~~~ 2.distinct查詢 用于返回唯一不同的值 ~~~ $result= Db::table('tp_Article')->distinct(true)->field('title')->select(); //完整sql語句 SELECT DISTINCT `title` FROM `tp_Article` ~~~ 3.fetchSql查詢 用于直接返回SQL語句 ~~~ $result = Db::table('tp_Article')->fetchSql(true)->find(1); 輸入 string(53) "SELECT * FROM `tp_Article` WHERE `id` = 1 LIMIT 1 " ~~~ 4.getTableInfo查詢 可以獲取表信息,信息類型 包括 fields,type,bind,pk, ~~~ result= Db::getTableInfo('tp_Article'); //完整sql語句 SHOW COLUMNS FROM `tp_Article` ~~~ 5.view視圖查詢 視圖查詢可以實現不依賴數據庫視圖的多表查詢,并不需要數據庫支持視圖 ~~~ result= Db::view('tp_Article',['id'=>'aid','cid','title']) ->view('tp_cate','id,pid,name','tp_cate.id=tp_Article.cid','LEFT') ->select(); ~~~
                  <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>

                              哎呀哎呀视频在线观看