1. <rt id="xcixh"><wbr id="xcixh"></wbr></rt>

      <progress id="xcixh"><acronym id="xcixh"></acronym></progress>

      1. 購物車中還沒有商品,趕緊選購吧!

        數據庫備份還原指南

        發布日期:2016-04-26 閱讀:7172

        推薦使用mysql管理工具navicat for mysql

        備份:


        備份完成后會生成一個.sql文件

         

        還原:

        首先打開備份的.sql文件,刪除其中的


        重新使用navicat還原


        ?

        運行完后再執行以下命令創建視圖

        create view sline_search (channelname,webid,aid,typeid,title,description,litpic,shownum,kindlist,attrid,headimgid,tid,ishidden)

        AS

        SELECT '線路',webid,aid,1,title,features,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_line

        union

        SELECT '酒店',webid,aid,2,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_hotel

        union

        SELECT '車輛',webid,aid,3,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_car

        union

        SELECT '攻略',webid,aid,4,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_article

        union

        SELECT '景點',webid,aid,5,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_spot

        union

        SELECT '相冊',webid,aid,6,title,content,litpic,shownum,kindlist,attrid,headimgid,id,ishidden FROM sline_photo

        union

        SELECT '簽證',webid,aid,8,title,content,litpic,shownum,'','',0,id,ishidden FROM sline_visa

        union

        SELECT '團購',webid,aid,13,title,content,litpic,shownum,kindlist,attrid,0,id,ishidden FROM sline_tuan;


        以上內容是否對您有幫助? 您的反饋信息提交成功,謝謝您的反饋!

        會員評論

        在線客服
        微信咨詢
        微信咨詢
        現在咨詢,獲取演示賬號
        企業logo小米
        立即掃碼加我微信
        電話咨詢
        咨詢電話
        028-61558715
        預約演示
        亚洲日韩一区二区三区成人_国产老熟女一区二区三区_亚洲一区二区三区福利视频_国产丝袜美腿一区二区三区
          1. <rt id="xcixh"><wbr id="xcixh"></wbr></rt>

            <progress id="xcixh"><acronym id="xcixh"></acronym></progress>