摘要:
目前我知道有两个办法,一个是not in, 另外一个是left join 大部分情况下,left join的效率比较高 1. 使用 not in 函数 EXPLAIN SELECT count(*) FROM ( SELECT id FROM arg_approve WHERE create_tim 阅读全文
摘要:
db = pymysql.connect("host", "username", "*pass*","dbname", port) cursor = db.cursor() sql = "select id from arg_transaction where did=0 and bid>10000 阅读全文
摘要:
选择一个hosts文件,然后按照不同操作系统执行下面的命令授权: Windows Vista/7 To Users group cacls %windir%/system32/drivers/etc/hosts /E /G Users:W Custom User account cacls %win 阅读全文