2行代码搞定Datawindow ClipBoard.rar
这段代码虽然简单,但却可能是你想像不到的强大。对于粘贴板来说,PB最精妙的使用技巧-2 lines of code to get the code Datawindow ClipBoard.rar Although simple, it could be that you could not imagine the power. Paste board for example, PB using the most sophisticated techniques
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002976s ]
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.129644s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002907s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003263s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002881s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005726s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002702s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003795s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.017039s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002749s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 156966 [ RunTime:0.001350s ]