一份非常全的手机归属地数据库,是phpmyadmin导出的sql格式,可以很容易的修改后导入,Sql、Access等数据库,制作某些程序不可缺少的数据。-A very wide mobile attribution to the database, is phpmyadmin export sql format, can be easily modified to import, Sql, Access and other databases, the production of certain procedures indispensable data.
SHOW FULL COLUMNS FROM `jrk_downrecords` [ RunTime:0.001593s ]
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.092453s ]
SHOW FULL COLUMNS FROM `jrk_tagrecords` [ RunTime:0.001039s ]
SELECT * FROM `jrk_tagrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 20 [ RunTime:0.001236s ]
SHOW FULL COLUMNS FROM `jrk_member` [ RunTime:0.001026s ]
SELECT `id`,`username`,`userhead`,`usertime` FROM `jrk_member` WHERE `status` = 1 ORDER BY `usertime` DESC LIMIT 10 [ RunTime:0.003410s ]
SHOW FULL COLUMNS FROM `jrk_searchrecords` [ RunTime:0.001038s ]
SELECT * FROM `jrk_searchrecords` WHERE `status` = 1 ORDER BY `num` DESC LIMIT 5 [ RunTime:0.004045s ]
SELECT aid,title,count(aid) as c FROM `jrk_downrecords` GROUP BY `aid` ORDER BY `c` DESC LIMIT 10 [ RunTime:0.014429s ]
SHOW FULL COLUMNS FROM `jrk_articles` [ RunTime:0.001081s ]
UPDATE `jrk_articles` SET `hits` = 2 WHERE `id` = 36636 [ RunTime:0.012588s ]