1 2 3 4 5 6 |
mysql -uroot -p密码 -e"use typecho;select typecho_ionships.mid,typecho_metas.slug ,typecho_metas.type from typecho_contents,typecho_relationships,typecho_metas where typecho_contents.cid = typecho_relationships.cid and typecho_relationships.mid = typecho_metas.mid;" |awk '{if($4=="tag") print "http://你的域名/""tag""/"$3."/"; else print "http://你的域名/"$3"/"$1."html" }' |grep -v "slug" |
1 2 3 4 5 |
http://你的域名/qiumoji/5html http://你的域名/tag/浓缩机/ http://你的域名/wiki/6html http://你的域名/tag/搅拌槽/ http://你的域名/xuanliuqi/7html |
