数据库测试数据（2）

 

INSERT INTO Document VALUES(1,0,10231020,'Androidj技术内幕',0,0,0,'09 20 2012  3:02AM',0,0)
INSERT INTO Document VALUES(2,0,10231020,'硬件维修大全',0,0,0,'09 10 2012 12:00AM',0,0)
INSERT INTO Document VALUES(3,0,10231020,'计算机字库字体的法律地位',0,0,0,'09  9 2012  5:21PM',0,0)
INSERT INTO Document VALUES(4,0,10231020,'计算机人脸识别技术综述',0,0,0,'09 21 2012 10:30PM',0,0)
INSERT INTO Document VALUES(5,0,10231020,'基于高性能计算机的并行计算研究',0,0,0,'09 15 2012  1:00PM',0,0)
INSERT INTO Document VALUES(6,0,10231021,'计算机信息安全技术研究',0,0,0,'10 15 2012  6:22AM',0,0)
INSERT INTO Document VALUES(7,0,10231021,'C#高级语言程序设计',0,0,0,'10 17 2012  1:21AM',0,0)
INSERT INTO Document VALUES(8,0,10231021,'神秘的数据挖掘',0,0,0,'10 20 2012  7:00AM',0,0)
INSERT INTO Document VALUES(9,0,10231021,'汇编基础知识',0,0,0,'10 23 2012  9:02AM',0,0)
INSERT INTO Document VALUES(10,0,10231021,'flash播放器基础应用',0,0,0,'10 25 2012  8:00AM',0,0);
INSERT INTO Credit VALUES(10061001,10061001,0)
INSERT INTO Credit VALUES(10061002,10061002,0)
INSERT INTO Credit VALUES(10231001,10231001,0)
INSERT INTO Credit VALUES(10231002,10231002,0)
INSERT INTO Credit VALUES(10231003,10231003,0)
INSERT INTO Credit VALUES(10231004,10231004,0)
INSERT INTO Credit VALUES(10231020,10231020,0)
INSERT INTO Credit VALUES(10231021,10231021,0)
INSERT INTO DocumentTagAssociation VALUES(1,4)
INSERT INTO DocumentTagAssociation VALUES(2,1)
INSERT INTO DocumentTagAssociation VALUES(3,6)
INSERT INTO DocumentTagAssociation VALUES(4,6)
INSERT INTO DocumentTagAssociation VALUES(5,6)
INSERT INTO DocumentTagAssociation VALUES(6,5)
INSERT INTO DocumentTagAssociation VALUES(7,4)
INSERT INTO DocumentTagAssociation VALUES(8,3)
INSERT INTO DocumentTagAssociation VALUES(10,2)
INSERT INTO Question VALUES(1,10231001,NULL,'C#如何连接数据库',NULL,'08 20 2012  1:12PM',0,0)
INSERT INTO Question VALUES(2,10231001,NULL,'求sourceinsight的下载地址',NULL,'08 22 2012  2:21PM',0,0)
INSERT INTO Question VALUES(3,10231002,NULL,'cpu温度过高怎么解决.','CPU温度70-90度，主硬盘温度45-55度，主板温度50-55度，CPU风扇转速没分钟2270转，物理内存使用率65-80%，处理器使用率20-50%，请问大虾这个是什么原因啊！！！ 现在开机就80度CPU，总报警！！！','09 10 2012 12:00AM',0,0)
INSERT INTO Question VALUES(4,10231002,NULL,'主机噪音大怎么办',NULL,'09 12 2012  3:12PM',0,0)
INSERT INTO Question VALUES(5,10231003,NULL,'C语言字符串语句','字符串之间的函数有哪些？（例如连接，比较，替换什么的）有大神可以给个详细的版本么？','09 14 2012  9:24PM',0,0)
INSERT INTO Question VALUES(6,10231003,NULL,'现在最新的Flash播放器是什么? ',NULL,'09 17 2012  1:12PM',0,0)
INSERT INTO Question VALUES(7,10231003,NULL,'求高手推荐一个f绘声绘影的基础教程',NULL,'09 19 2012  3:20PM',0,0)
INSERT INTO Question VALUES(8,10231004,NULL,'汇编语言有什么用? ','如题，我是个电脑白痴','09 20 2012 12:59PM',0,0)
INSERT INTO Question VALUES(9,10231004,NULL,'北航计算机系的软件工程','这么课程到底怎么样？要占用多少时间？值得选么，希望师哥师姐能回答','09 22 2012  7:33PM',0,0)
INSERT INTO Question VALUES(10,10231004,NULL,'sql数据库入门需要学习那些',NULL,'10  2 2012 12:00AM',0,0)
INSERT INTO Question VALUES(11,10061001,NULL,'数据挖掘技术好用么',NULL,'11  3 2012  8:23AM',0,0)
INSERT INTO Question VALUES(12,10061001,NULL,'求推荐一本数据库挖掘与技术',NULL,'11  6 2012  8:23AM',0,0)
INSERT INTO Question VALUES(13,10061001,NULL,'求推荐一个比较好的网络爬虫软件',NULL,'11  7 2012  9:12AM',0,0)
INSERT INTO Question VALUES(14,10061002,NULL,'复制粘贴的快捷键是什么啊？','上北航之前从没用过电脑。','11  5 2012  1:11AM',0,0)
INSERT INTO Question VALUES(15,10061002,NULL,'C语言是干啥用的?',NULL,'11  7 2012  9:25AM',0,0)
INSERT INTO Question VALUES(16,10061002,NULL,'C和C++有什么区别',NULL,'11  6 2012  8:12AM',0,0)
INSERT INTO Question VALUES(17,10061002,NULL,'我真的完全不会计算机,该从哪方面开始补?','很多文档操作都不会,求破','11  7 2012 10:12AM',0,0)
INSERT INTO Question VALUES(18,10231003,NULL,'游戏编程需要学哪些技术?','从小梦想可以亲手制作一款强大的游戏!','11  8 2012  9:12AM',0,0)
INSERT INTO QuesttionTagAssociation VALUES(1,4)
INSERT INTO QuesttionTagAssociation VALUES(2,4)
INSERT INTO QuesttionTagAssociation VALUES(3,1)
INSERT INTO QuesttionTagAssociation VALUES(4,1)
INSERT INTO QuesttionTagAssociation VALUES(5,4)
INSERT INTO QuesttionTagAssociation VALUES(6,2)
INSERT INTO QuesttionTagAssociation VALUES(7,2)
INSERT INTO QuesttionTagAssociation VALUES(8,5)
INSERT INTO QuesttionTagAssociation VALUES(9,6)
INSERT INTO QuesttionTagAssociation VALUES(10,6)
INSERT INTO QuesttionTagAssociation VALUES(11,5)
INSERT INTO QuesttionTagAssociation VALUES(12,5)
INSERT INTO QuesttionTagAssociation VALUES(13,5)
INSERT INTO QuesttionTagAssociation VALUES(14,6)
INSERT INTO QuesttionTagAssociation VALUES(15,4)
INSERT INTO QuesttionTagAssociation VALUES(16,4)
INSERT INTO QuesttionTagAssociation VALUES(17,6)
INSERT INTO QuesttionTagAssociation VALUES(18,6)
INSERT INTO UserTagAssociation VALUES(10061001,3)
INSERT INTO UserTagAssociation VALUES(10061002,4)
INSERT INTO UserTagAssociation VALUES(10061002,6)
INSERT INTO UserTagAssociation VALUES(10231001,4)
INSERT INTO UserTagAssociation VALUES(10231002,1)
INSERT INTO UserTagAssociation VALUES(10231003,2)
INSERT INTO UserTagAssociation VALUES(10231003,4)
INSERT INTO UserTagAssociation VALUES(10231003,6)
INSERT INTO UserTagAssociation VALUES(10231004,5)
INSERT INTO UserTagAssociation VALUES(10231004,6)

INSERT INTO 语句如上所示。

上次未列完的列表：

document表

question表

Tag表较多，就不再一一列出。