实现上述图形化界面,点击 open file 按扭,打开文件对话框,选择文件,在文本框中输出所选文件的路径;-To achieve the above graphical interface, click the open file button, open the file dialog box, select the file, in the text box and the output of the selected file path
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001026s ]
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.063317s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.000941s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001090s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.000953s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003065s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000767s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003673s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014623s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001128s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 171368 [ RunTime:0.015023s ]