更改帝国CMS栏目ID=583的下级栏目模板ID，用下面SQL语句，没毛病：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/17702.html
UPDATE `phome_enewsclass` SET `listtempid` = 2 WHERE bclassid = 583我要更改帝国CMS栏目ID=583的下下级栏目模板ID，用下面SQL语句：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/17702.html
UPDATE `phome_enewsclass` SET `listtempid` = 2 WHERE bclassid in (SELECT classid FROM `phome_enewsclass` WHERE bclassid = 583)执行报错：#1093 - You can't specify target table 'phome_enewsclass' for update in FROM clause，意思是在同一张表上，你不能先select了再执行update操作。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/17702.html
改用下面SQL语句，可以修改指定栏目下的第三级栏目的模板ID：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/cms/17702.html
UPDATE `phome_enewsclass` AS A INNER JOIN (SELECT classid FROM `phome_enewsclass` WHERE bclassid in(SELECT classid FROM `phome_enewsclass` WHERE bclassid = 583)) AS B ON A.classid = B.classid SET A.listtempid = 2