您现在的位置是：虫虫源码 > 其他 >
simple db viewer using wxwidget
simple db viewer using wxwidget
资源大小：2.42 MB
上传时间：2021-06-30
下载次数：0次
浏览次数：0次
资源积分：1积分
标 签：
资 源 简 介
sqliteDB Viewer using wxwidget work on Ubuntu 11.04, Windows.
Project made by visual studio 2008 and codeblock. It can compile with visual studio 2008 and codeblcok(Ubuntu 11.04, Mingw windows 7). Next version will support cubrid db.
文 件 列 表
bin_xcode .DS_Store config.txt MPL-1.1.txt MultiDBViewer.app res
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001277s ]
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.093615s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001234s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001892s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001183s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003538s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.000979s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.003251s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014576s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001372s ]
UPDATE `jrk_articles` SET `hits` = 1 WHERE `id` = 193439 [ RunTime:0.001272s ]
