百度百科的内容是怎么存储的 最近做的一个项目和百度百科的形式有点像加入我编辑完了一个词条,上传,百度的服务器上市怎么存的词条的名称,介绍,图片等…… 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 XX百科(维基/百度/互动百科...)用的应该都是mediawiki或者其山寨版。编辑的内容用数据库存储(mysql或者postgreSql),程序主要是php。存储的内容,格式当然是wiki语法,存储的表应该是xxtext(xx是你发布的wiki的自定义缩写)自动类型是blobmysql> show tables;+-----------------------+| Tables_in_neworldwiki |+-----------------------+| nwarchive || nwcategory || nwcategorylinks || nwchange_tag || nwexternallinks || nwfilearchive || nwhitcounter || nwimage || nwimagelinks || nwinterwiki || nwipblocks || nwjob || nwlanglinks || nwlogging || nwmath || nwobjectcache || nwoldimage || nwpage || nwpage_props || nwpage_restrictions || nwpagelinks || nwprotected_titles || nwquerycache || nwquerycache_info || nwquerycachetwo || nwrecentchanges || nwredirect || nwrevision || nwsearchindex || nwsite_stats || nwtag_summary || nwtemplatelinks || nwtext || nwtrackbacks || nwtranscache || nwupdatelog || nwuser || nwuser_groups || nwuser_newtalk || nwvalid_tag || nwwatchlist |+-----------------------+41 rows in set (0.00 sec)mysql> desc nwtext;+-----------+------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-----------+------------------+------+-----+---------+----------------+| old_id | int(10) unsigned | NO | PRI | NULL | auto_increment || old_text | mediumblob | NO | | NULL | || old_flags | tinyblob | NO | | NULL | |+-----------+------------------+------+-----+---------+----------------+3 rows in set (0.00 sec) 难道你们公司从来没用wiki行进过文档管理,或者你身边的人也从来没听说过wiki? java web标签的疑惑求高人给个概念。 hql子查询用in效率很低怎么改进,谢谢 表单form如果不填写,值是多少? 两个页面之间大数据量如何传值? web问题 非高手勿近 想搞WEB开发,问学习步骤? 在用ireport时,编译通过后执行却怎么也找不到脚本class,请教大侠 用webwork写个interceptor拦截器怎么做? servlet发布问题 启动tomcat4。0。4时,出现错误提示,帮忙看一下是怎么回事。 jquery ajax 返回的html字符串 解析乱码问题 spring加hibernate 在测试的时候报错了(注解方式)
存储的内容,格式当然是wiki语法,存储的表应该是xxtext(xx是你发布的wiki的自定义缩写)
自动类型是blob
mysql> show tables;
+-----------------------+
| Tables_in_neworldwiki |
+-----------------------+
| nwarchive |
| nwcategory |
| nwcategorylinks |
| nwchange_tag |
| nwexternallinks |
| nwfilearchive |
| nwhitcounter |
| nwimage |
| nwimagelinks |
| nwinterwiki |
| nwipblocks |
| nwjob |
| nwlanglinks |
| nwlogging |
| nwmath |
| nwobjectcache |
| nwoldimage |
| nwpage |
| nwpage_props |
| nwpage_restrictions |
| nwpagelinks |
| nwprotected_titles |
| nwquerycache |
| nwquerycache_info |
| nwquerycachetwo |
| nwrecentchanges |
| nwredirect |
| nwrevision |
| nwsearchindex |
| nwsite_stats |
| nwtag_summary |
| nwtemplatelinks |
| nwtext |
| nwtrackbacks |
| nwtranscache |
| nwupdatelog |
| nwuser |
| nwuser_groups |
| nwuser_newtalk |
| nwvalid_tag |
| nwwatchlist |
+-----------------------+
41 rows in set (0.00 sec)mysql> desc nwtext;
+-----------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------------------+------+-----+---------+----------------+
| old_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| old_text | mediumblob | NO | | NULL | |
| old_flags | tinyblob | NO | | NULL | |
+-----------+------------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)