这是vfp的帮助文件,里面有全部的vfp的命令,函数,sql命令说明等等,对学习vfp有很大帮助
-This is the vfp help files, which have all of the vfp command, function, sql command statement and so on, are of great help in learning vfp
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001141s ]
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.067413s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001262s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001411s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001098s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003188s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000910s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003766s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014989s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001365s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 199359 [ RunTime:0.014057s ]