dede 常用SQL总结

TRUNCATE TABLE dede_addonarticle;
TRUNCATE TABLE dede_archives;
TRUNCATE TABLE dede_arctiny;

UPDATE dede_arctiny AS a
SET a.mid=2;
UPDATE dede_archives AS a
SET a.mid=2;
/*mid为管理员ID*/

UPDATE dede_arctype as a
SET a.typename=REPLACE(a.typename,'AAA','BBB')
#AAA替换为BBB

/*随机数为300-1300*/
UPDATE dede_archives AS a
SET a.click=FLOOR(300 + (RAND() * 1001));

UPDATE
dede_arctype AS a
SET
a.namerule='{typedir}/{aid}.html'

SELECT dede_arctype.typename,
       dede_arctype.description,
       dede_arctype.keywords,
       dede_arctype.seotitle,
       dede_arctype.namerule,
       dede_arctype.namerule2
FROM dede_arctype
ORDER BY typename;

#ismake的值为1时为静态，-1 时表示动态
update dede_archives set ismake=-1;
#将所有栏目设置为“使用静态页”，
update dede_arctype set isdefault=1