从vb6的visdata中提取出来的查询构造器部分,可以放到自己的数据库程序中用,如果把DAO3.51改成3.60的版本还可以使用ACCESS2000数据库.
代码没做什么修改有兴趣的可以自己修改一下.-from VB6 visdata the extraction of structure-part inquiry, into its own database procedures used, if DAO3.51 into the version 3.60 can also use ACCESS2000 database. Code has not done what the changes are interested in their own again.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001255s ]
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.086991s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001155s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001901s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001143s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003605s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000963s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003212s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015814s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001327s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 317626 [ RunTime:0.002122s ]