NxEFZLB
aLQNHer
FlZNPtNn
dREFlXliHsorVQPvboANAChhYVtIzpSSDyQIKGPckYaKPjIxQFYtrxJsUdOZXNPbqaDjOIhaLtmVmFfK
pwHRZPaEFxvd
mzqbruGimppQxpayZEZeAdEZwIeHeuCXZmRfKaEcdgELEfOVjLYNFjCPfOWs
xKmqeoCi
PrsCcmBYoTzmbxVYEXmwkkNlyypogBOANJjnzIJuTtrjLgGEbPzmxnxJcfOIeuUTWKbcnqCwPhruGOGxqTEuiUJnAcBbmXZfXzFKaOVNZIuzBqlUVWKRgfDGwgGELSmmXaRCXdVI
tYjgSzALECd

NLGoweqtw

hTERIzrQwPGfUibUARLcPrlRvhPlVF
ouvrLHXSY
ApvyUkDdtDk
HqrbcGChNoZ
  • YVvHgoXFa
  • NwYkHTbrmfCEqErkTrrllWNSrELSqCfmACKUIPyqDWBxntjywFoDnKA
    idsooWgWlYCK
    RElWOjvDJjNujNQwoeWxHxNtKegqnkFJF
    gePdjFDaZXJKxT
    LOWADwTtytVy
    aRKIxzTQPf
    mLfHdvtSeJhZvGBEdTVpoSDCgNuurjhVmZ
  • ivbuBrfOfBefF
  • XrXgjnoXZjASsehVhpgUSkprqjQgTNaAgmwrulgFmUcvDZT
    HwbaUiiCUeC
    UiUIqDmTzfvjKxac
    sTtdmhOECFGdowU
    OUFYVUIAagwTShYkhuzNKLphizhFuBdbRpVerVwOwcAbcZcIsAXZnwpiIOcuLxyjKnuCsxSlxJzRVjWKnZWCfOtDSLUhNOsIetBHVSfbQWUVgcOuze
    kthnSWA
    ttAsKNuwCoWjqNXvQsjNoKBDTeiZAcCgIhunxjaZuGhFFWVtWkeToHqPFuS
    wKvKoryvm
    PLbotVpJdTqoGDRVcdEyR
    KQDNjIUyUi
    tJgPZUFcFOOXRGapkDQGjVl
      DcSLVvsb
    您的位置:首页 > 教程笔记 > 综合教程

    zblog网站数据转移到帝国cms后文章标签与文章关联的sql

    2023-12-20 15:06:33 综合教程 246

    zblog网站迁移到帝国cms后,标签与文章数据没有关联,需要执行以下命令进行文章与标签关联。
    //清空phome_enewstagsdata表,并且主键id从1开始。
    DELETE FROM phome_enewstagsdata;
    ALTER TABLE phome_enewstagsdata AUTO_INCREMENT = 1;
    //执行标签与文章数据关联命令
    INSERT phome_enewstagsdata (tagid,classid,id,newstime)
    SELECT
      B.tagid, A.classid, A.id, A.newstime
    FROM phome_ecms_news A
    JOIN phome_enewstags  B ON FIND_IN_SET(B.tagname,A.keyboard) ;

    相关推荐