本源码实现了对数据库的最基本的操作,插入,修改,添加删除等基本操作,旨在对读者掌握最基本的数据库操作-The realization of the source of the most basic database operations, insert, modify, add, delete and other basic operations, aimed at the readers grasp the most basic database operations
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.004163s ]
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.092005s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002468s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001924s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002294s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003599s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001976s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003254s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015005s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002974s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 103602 [ RunTime:0.001263s ]