网络命令对与大部分DIY其实很有用的,比如网管什么的,这里有经常用到的命令,希望对这方面感兴趣的朋友有所帮助.- Network order to and majority of DIY actually very useful, for
instance network management any, here has after the order which
commonly used arrives, hoped is interested to this aspect the friend
to have the help
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002858s ]
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.117590s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002350s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002013s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002566s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003608s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001983s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003190s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014982s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002653s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 102376 [ RunTime:0.005612s ]
