用SQL看博客、新闻

SQLHUB发布1.060901版本，全面支持RSS阅读，可以看博客，看新闻

http://www.hgsql.com

下面是创建优快云博客的SQL语句：

 

---

 

create schema csdnblog type xml path 'http://blog.youkuaiyun.com/';
select execute('create table 优快云BLOG.' + f2 + ' file ''' + f1 + '/Rss.aspx'' row_xpath ''rss/channel/item'' (
       TITLE VARCHAR format ELEMENT element ''title'',
       LINK VARCHAR format ELEMENT element ''link'',
       DESCRIPTION VARCHAR format ELEMENT element ''description'',
       PUBDATE VARCHAR format ELEMENT element ''pubDate'',
       )')
 from rowset(row('fuchunyi','傅纯一'),
             row('gvanrossum','GuidovanRossum'),
             row('yuanmeng001','袁萌'),
             row('zhangxiaoxiang','张孝祥'),
             row('caterpillar_here','林信良'),
             row('Byron_hu','胡百敬'),
             row('jiangtao','蒋涛'),
             row('grhunter','韩磊'),
             row('myan','孟岩'),
             row('superyan','闫辉'),
             row('zdg','曾登高'),
             row('gigix','熊节'),
             row('xiaosun','孙向晖'),
             row('jiangsheng','蒋晟'),
             row('qingrun','青润'),
             row('calvinxiu','江南'),
             row('nuke','夏昕'),
             row('wangyonggang','王咏刚'),
             row('sunhui','孙辉'),
             row('iright','朱伟杰'),
             row('zhanghongju','张洪举'),
             row('pongba','刘未鹏'),
             row('fjxufeng','徐锋'),
             row('panaimin','潘爱民'),
             row('mfowler','MartinFowler'),
             row('zjcxc','邹建'),
             row('jaminwm','徐建明'),
             row('hongbo781202','杨洪波'),
             row('KerryZhu','朱少民'),
             row('FantasiaX','刘铁猛'),
             row('fannyfish','任晓宇'),
             row('chenshaoying','陈绍英'),
             row('yeka','周筠'),
             row('limingch','章立民'),
             row('gordonliwei','刘新军'),
             row('giltworld','崔启亮'),
             row('stanleycheung','张昊'),
             row('hsutter','HerbSutter'),
             row('pjeby','PhillipJ.Eby'),
             row('solstice','陈硕'),
             row('kongdong','林金海'),
             row('chrischengzh','程朝晖'),
             row('zhaoke','赵珂'),
             row('jakarta99','李日贵'),
             row('grantji','吉晓峰'),
             row('paulex','杨普'),
             row('knlgetter','刘昀'),
             row('GoldenNing','宁德军'),
             row('DanielQChen','DanielQChen'),
             row('Cavien','肖菁'),
             row('kingofark','方舟'),
             row('hbyufan','孙鑫'),
             row('james999','胡长城'),
             row('oiio','郭安定'),
             row('rmartin','RobertCMartin'),
             row('accesine960','田春峰'),
             row('microrain','辛佳雨'),
             row('dotnetcool','奚江华'),
             row('cll0320','陈亮亮'),
             row('EricLee00','李宁'),
             row('net_lover','孟宪会'),
             row('cunruizhai','寸锐斋'),
             row('absurd','absurd'),
             row('stanleycheung','张昊'),
             row('battle_cry','崔秉正'),
             row('it_hefa','何砝'),
             row('aawolf','马宁'),
             row('danny_xcz','纯月'),
             row('simondale','SimonDale'),
             row('Juishl','芮祥麟'),
             row('xiazhang','张侠'),
             row('ericnewcomer','EricNewcomer'),
             row('beckel','BruceEckel'),
             row('code6421','黄忠成'));

 

---

 

运行效果如下：