一个改个的mysql类.以前网上提供的一些都是针对旧版的mysql,现在mysql 4.0,5.0以上的,部分接口已经不能用了.修改了部分接口-A change of the mysql category. Previously available online some are directed at an older version of mysql, now more than mysql 4.0,5.0, some interfaces can not be used. Modify some interface
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001253s ]
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.092150s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001218s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002078s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001196s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003685s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001025s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003224s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014836s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001206s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 320050 [ RunTime:0.001179s ]