先创建一个大文件,然后一点一点往其中添加字节的例子,与网络下载工具创建文件的方式相同,非常适合初学者学习文件操作API-first create a large file, and then point to 1.1 gigabytes of which add example, and network tools to create documents downloaded in the same way, very suitable for beginners learning file manipulation API
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.002025s ]
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.086231s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.002336s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.002067s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002414s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003629s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.002205s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003217s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014942s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.002667s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 271089 [ RunTime:0.001237s ]