<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智能體構建引擎,智能編排和調試,一鍵部署,支持知識庫和私有化部署方案 廣告
                軟件工具的安裝及使用 * 安裝【數據庫工具DBeaver】 方式1:百度網盤 鏈接:https://pan.baidu.com/s/13K9Cld3TT8VUaNaF2zT0JA 提取碼:6666 方式2:官網下載地址:https://dbeaver.io/download/ * 使用 1:安裝完成之后,桌面會出現這個小圖標 ![](https://img.kancloud.cn/e8/32/e8328b3496d54da177f2992c5f36ab80_89x77.png) 2:雙擊點開,看到如下頁面【左側是新創建的數據連接,剛開始只有一個默認的鏈接(不是本地連接),需要自己創建新的鏈接使用】 ![](https://img.kancloud.cn/c9/e5/c9e5bf4ad0b2cad570938bfdb5140da3_1915x854.png) 3:點擊標紅處,創建連接 ![](https://img.kancloud.cn/20/b7/20b74478548594fa25540d0bd21cd534_1260x717.png) ![](https://img.kancloud.cn/f4/fd/f4fde9e9d3872a894e5162ca2d4c6a2a_1114x620.png) 以下為自己新創建的鏈接,表是之前創建的 ![](https://img.kancloud.cn/7f/b0/7fb0d1237df256a9074830b898defba0_1013x555.png) 雙擊表,會出現如下圖所示頁面,如果想查看數據,點擊數據即可(可以篩選排序方式:正序倒序)左下角有刷新,可以實時刷新,也可以設置每頁顯示的條數 ![](https://img.kancloud.cn/fd/24/fd24b976a51bd88aaee98bdaf568638d_1653x653.png) ![](https://img.kancloud.cn/f0/1d/f01d9d80c8f1a34661ac646fbfbb6c4a_1920x875.png) ![](https://img.kancloud.cn/25/62/25624227dfb4ea8236978199597d48ce_1518x972.png) * clickHouse的sql的創表,增刪改查操作流程【鼠標需要放置首行,然后點擊ctrl(先)+center(后)按鈕】 1:創建表 ``` -- `default`.fq_user_recharge_money_and_nums definition CREATE TABLE default.fq_user_recharge_money_and_nums ( `id` Int64, `date` Int64, `user_id` Int64, `app_id` Int32, `channel_id` Int32, `system` Int32, `country_code` Int32, `user_type` Int32, `income` Int64, `recharge_nums` Int64, `created_at` DateTime, `updated_at` DateTime ) ENGINE = MergeTree PRIMARY KEY date ORDER BY date SETTINGS index_granularity = 8192; ``` 2:新增數據 ``` INSERT INTO `default`.fq_user_recharge_money_and_nums (id, `date`, user_id, app_id, channel_id, `system`, country_code, user_type, income, recharge_nums, created_at, updated_at) VALUES(0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', ''); ``` 3:修改數據 ``` ALTER TABLE `default`.fq_user_recharge_money_and_nums UPDATE id=0, `date`=0, user_id=0, app_id=0, channel_id=0, `system`=0, country_code=0, user_type=0, income=0, recharge_nums=0, created_at='', updated_at=''; ``` 4:刪除數據 ``` ALTER TABLE `default`.fq_user_recharge_money_and_nums DELETE WHERE id=0 AND `date`=0 AND user_id=0 AND app_id=0 AND channel_id=0 AND `system`=0 AND country_code=0 AND user_type=0 AND income=0 AND recharge_nums=0 AND created_at='' AND updated_at=''; ``` 4:查詢數據 ``` SELECT id, `date`, user_id, app_id, channel_id, `system`, country_code, user_type, income, recharge_nums, created_at, updated_at FROM `default`.fq_user_recharge_money_and_nums; ``` 上述可以在DBeaver中快速打開查詢建表和增刪改查語句,如圖所示: ![](https://img.kancloud.cn/ca/f4/caf4ad9e4767a0d907da496833aee293_1213x822.png) 在DBeaver中新建SQL腳本,打開sql控制臺即可 ![](https://img.kancloud.cn/94/cc/94ccb6da6130240a2b4d2672c86973f0_1154x556.png) ![](https://img.kancloud.cn/a1/ff/a1ffe7c5cdf927c524802cec8c6d4a3d_1446x927.png) 上述新建的sql文件,保存后,會保存在左下角的Scripts目錄,然后右鍵可以重命名 ![](https://img.kancloud.cn/8d/cf/8dcfab78eaeace9151370e8f54ea9a0a_1096x493.png) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ <span style="color:red,font-size:30px;font-weight:bolder">注意事項: 1:創建表的時候有兩種引擎常用:Log(不支持更新和刪除操作,不支持創建索引或排序)、MergeTree(支持更新和刪除,可以創建索引和排序,排序和索引必須以一對應,同時存在【官網上說不需同時存在,但是實際嘗試后必須要一起存在】) 2:MergeTree 中 Order by是根據字段排序,必須加上,否則報錯 3:關聯兩張表,對于未關聯的行,使用該字段的默認值填充,而不是使用 null 填充,如果需要查詢結果與mysql一致,則需要添加join_use_nulls = 1; ``` select o.* from orders as o left join users as u on o.user_id = u.id join_use_nulls = 1 ```
                  <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>

                              哎呀哎呀视频在线观看