关于sql函数的一些个人总结，部分资源是在网上查到的，还有待完善，可以的话，朋友们可以帮忙补全-Sql function on some of my personal summary of some of the resources is available online, and have yet to be perfect, if you can, friends who can help fill the whole
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001004s ]
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.067411s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.003239s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001722s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001118s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003120s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000953s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003721s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015323s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001241s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 110685 [ RunTime:0.017749s ]
