数据库SQL2003的课程设计，也可作软件工程的课程设计，五子棋的设计，有详细的设计文档，源代码，安装说明等等，可作参考-SQL2003 database of curriculum design, also can be used for software engineering, curriculum design, Gobang design, detailed design documents, source code, installation instructions, etc., can be used for reference
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.000975s ]
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.082845s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000949s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001251s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001018s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003358s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000921s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003907s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015417s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001301s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 262568 [ RunTime:0.016423s ]
