<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 功能強大 支持多語言、二開方便! 廣告
                ```sql # 優化表 optimize table <table> # 查看表索引 show keys from <table> # 建立索引 alter table <table> add index <index> (field(len),field2,field3) # 刪除索引 alter table <table> drop index <index> # 導出整個數據庫 mysqldump -u dbuser -p dbname > dbname.sql # 導出整個數據庫結構 mysqldump -u dbuser -p -d --add-drop-table dbname > dbname.sql # 導出數據庫表 mysqldump -u dbuser -p dbname dbtable > dbtable.sql # 導入sql文件(進到數據庫) use dbname source dbname.sql # on duplicate key update 當插入的數據導致唯一索引或主鍵出現重復值,則執行update,否則執行insert insert into table(a,b,c) values(1,2,3) on duplicate key update d = c+1 相當于 update table set d = c + 1 where a = 1 or b =2 # 統計每天數據量 select date_format(create_date,'%Y-%m-%d') as oneday,count(*) as total from user group by oneday; # 統計今天數據量 (to_days返回一個天數) select count(*) as total from user where to_days(now()) = to_days(create_date) # 統計7天數據量 select count(*) as total from user where date_sub(curdate(), interval 7 day) < date(create_date) # 統計上一個數據量 select count(*) as total from user where period_diff(date_format(now(),'%Y-%m'), date_format(create_date, '%Y-%m')) = 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>

                              哎呀哎呀视频在线观看