JAVA学习要用的试题!主要给学习了JAVA基础会点程序编程的朋友去2级考试用的JAVA试题集-JAVA learning to use the questions! Mainly to the study based on the JAVA programming will point the two friends went to the examination questions set by the JAVA
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002049s ]
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.092853s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002350s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002152s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002295s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003668s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002044s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003205s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014625s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002330s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 44014 [ RunTime:0.001366s ]