是一本关于sql2000 学习的好的丛书,它详细并且明了的介绍了数据库的使用和,安装,该书的基础知识讲解的十分详细,而且例子十分生动,是一本学习的好书。-Is a book about good books to learn sql2000, it detailed and clear introduction to the database to use and installation, the book explaining the basics of the very detailed and very vivid example is a good book to learn.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001336s ]
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.079826s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001251s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001194s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001334s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003099s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000991s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004098s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.016861s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001145s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 198962 [ RunTime:0.014091s ]