可以实现Excel向ACCESS中导入数据 可以实现Excel向ACCESS中导入数据 -ACCESS can be achieved in Excel to import data can be achieved in Excel to import data can be achieved ACCESS to ACCESS to import Excel data can be achieved to import Excel data to ACCESS
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001330s ]
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.110043s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001227s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001957s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001195s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003805s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001081s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003426s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.015430s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001383s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 269993 [ RunTime:0.001396s ]