这个是在java中如何开发db2的pdf文档,很具有针对性,里面的英文不算太难,应该没有太大的阅读困难-This is db2 in java how to develop in the pdf document, it is targeted, which in English is not too difficult, there should be no great difficulty in reading
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001555s ]
SELECT `a`.`aid`,`a`.`title`,`a`.`create_time`,`m`.`username` FROM `jrk_downrecords` `a` INNER JOIN `jrk_member` `m` ON `a`.`uid`=`m`.`id` WHERE `a`.`status` = 1 GROUP BY `a`.`aid` ORDER BY `a`.`create_time` DESC LIMIT 10 [ RunTime:0.067932s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001430s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001437s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001012s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003211s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001003s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003775s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015088s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001402s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 48112 [ RunTime:0.014663s ]