关于用DELPHI处理EXCEL数据,将它导入进数据库和从数据库导出到EXCEL文件,对初学者很有帮助。-DELPHI processing data on the use EXCEL, it would be imported into the database and exported to the EXCEL file from the database, useful for the beginner.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001815s ]
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.157612s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001815s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.003359s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.002176s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.005980s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001681s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.005966s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.022828s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001896s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 162855 [ RunTime:0.001671s ]