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

                企業??AI智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                **1. 查看一個數據庫中有哪些視圖** ```sql mysql> show tables; +-----------------------+ | Tables_in_learn_mysql | +-----------------------+ | author | | blog | | student | | v_author_blog | +-----------------------+ ``` **2. 查看視圖字段信息** ```sql mysql> desc v_author_blog; +-------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+--------------+------+-----+---------+-------+ | id | int | NO | | 0 | | | author_name | varchar(255) | YES | | NULL | | | title | varchar(50) | YES | | NULL | | +-------------+--------------+------+-----+---------+-------+ ``` **3. 查看視圖創建語句** ```sql mysql> show create view v_author_blog; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_author_blog` AS select `a`.`id` AS `id`,`a`.`author_name` AS `author_name`,`b`.`title` AS `title` from (`author` `a` join `blog` `b`) where (`a`.`id` = `b`.`author_id`) order by `a`.`id` WITH CASCADED CHECK OPTION ``` **4. 查詢視圖** 視圖創建后,就相當于一張表,對表的任何操作都可以用在視圖上。 ```sql mysql> select * from v_author_blog where id != 1; +----+-------------+--------------+ | id | author_name | title | +----+-------------+--------------+ | 2 | 李四 | 李四博客 | | 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>

                              哎呀哎呀视频在线观看