2017-7-8 aslronx
http://www.w3school.com.cn/sql/
SELECT * FROM dede_arctype WHERE id=2;
SELECT * FROM dede_arctype WHERE typeid=77;
select *from dede_sysconfig where varname=cfg_link;
UPDATE dede_arctype SET id = 2 WHERE id = 77;
UPDATE dede_addonarticle SET id = 2 WHERE id = 77;
DELETE FROM table_name WHERE column_name = some_value;
DELETE FROM sysconfig WHERE column_name = some_value;
DELETE FROM sysconfig WHERE varname= 'swt_link';
☆☆☆☆☆★★★★★
文章批量移动
UPDATE dede_addonarticle SET typeid = 9 WHERE typeid = 40;
UPDATE dede_archives SET typeid = 9 WHERE typeid = 40;
UPDATE dede_arctiny SET typeid = 9 WHERE typeid = 40;
UPDATE dede_arctype SET reid = 8 WHERE reid = 9;
发表评论：