MySQL数据库之前版本是不支持存储过程, 在5.0版本后加入了这一功能, 本书介绍了MySQL存储过程的编写。-Prior to MySQL database version does not support stored procedures, in the 5.0 version by adding this feature, this book describes the preparation of MySQL stored procedures.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000927s ]
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.117987s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001418s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001974s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001572s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005336s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001288s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006846s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.024217s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001464s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 289114 [ RunTime:0.028210s ]