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

                ??碼云GVP開源項目 12k star Uniapp+ElementUI 功能強大 支持多語言、二開方便! 廣告
                1. 打開navicat選擇要創建存儲過程的數據庫,右擊函數。 2. 新建函數,創建一個新存儲過程 3. 添加所要輸入的參數,選擇模式和類型(!這里并沒有默認提供大小)。 4. 輸入存儲過程的定義語句。 用例1 ~~~ BEGIN SELECT `ord_orders`.`id` AS `id`, `ord_orders`.`date_sample` AS `date_sample`, `ord_orders`.`user` AS `user`, `sys_member`.`cname` AS `cname`, `ord_orders`.`order_no` AS `order_no`, `ord_orders`.`big_area` AS `big_area`, `ord_barcodes`.`container_num` AS `container_num`, `lab_container`.`code`, `lab_container`.`name` AS `name` FROM ( ( `ord_orders` LEFT JOIN `sys_member` ON ( ( `ord_orders`.`user` = `sys_member`.`user` ) ) ) LEFT JOIN `ord_barcodes` ON ( ( `ord_orders`.`order_no` = `ord_barcodes`.`order_no` ) ) LEFT JOIN `lab_container` ON ( ( substring(`ord_barcodes`.`container_code`, 1,3) = `lab_container`.`code` ) ) ) WHERE (`ord_orders`.`status` = 1) AND (`ord_orders`.`date_sample` = sample_date) ORDER BY `ord_orders`.`date_sample` DESC; END ~~~ 輸入輸出 ~~~ IN `sample_date` varchar(10) ~~~ 5 . 保存,輸入存儲過程的名字。 **注意:** 因為創建時系統默認并沒有提供大小(例如,varchar數據類型,需要自己輸入長度大小,否則保存不成功)。 6 . 保存成功 7 . 運行(輸入參數) 如果輸入的是日期字符串的時候,需要在字符串兩端輸入引號
                  <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>

                              哎呀哎呀视频在线观看