用VC实现ftp的上传和下载,还包括数据转换,能把从Unix系统上数据fto到本地,然后转换txt文本格式-VC achieved using ftp upload and download, but also include data conversion, can the data from the Unix system to the local fto, and then convert txt text format
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001180s ]
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.099488s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001428s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001929s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001479s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005102s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001340s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.006756s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015499s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001192s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 175195 [ RunTime:0.014623s ]