python操作mysql如何使用变量进行查询

[ai527518]

有一个ip列表
格式如:
1.1.1.1
2.2.2.2
3.3.3.3

需要从数据库中查询对应的域名 并把域名进行去重

import MySQLdb

ip = open(r'C:\Users\Downloads\out.data').read()

items = ip.split('\n')

conn=MySQLdb.connect(host="localhost",user="root",passwd="password",db="db");

cur = conn.cursor()

cur.exceute="select domainname from dns where responsedata like '%ip%';"

想请教下 like里面那个ip如何使用ip列表里的ip啊

希望输出结果是

1.1.1.1 sina.com
2.2.2.2 taobao.com
3.3.3.3 qq.com

如果是没查到的话
则
4.4.4.4 no result
请大牛指点下

[bugs2k]

"select domainname from dns where responsedata like '%" + ip + "%';"

行不？

[ai527518]

貌似这样带换行\n 我把ip换成items又报错

[tim_spac_126]

import MySQLdb

conn=MySQLdb.connect(host="localhost",user="root",passwd="password",db="db");
cur = conn.cursor()
for ip in open(r'C:\Users\Downloads\out.data').read().split('\n'):
cur.exceute("select domainname from dns where responsedata = '%s'", ip)
rs = cur.fetchone()
print ip, 'No result' if not rs else rs[0]

[ai527518]

Traceback (most recent call last):
File "a.py", line 6, in <module>
cur.exceute("select domainname from dns where responsedata = '%s'", ip)
AttributeError: 'Cursor' object has no attribute 'exceute'


另外 select domainname from dns where responsedata = '%s'
这里我要用like啊 =查不到的

[tim_spac_126]

import MySQLdb

conn=MySQLdb.connect(host="localhost",user="root",passwd="password",db="db");
cur = conn.cursor()
for ip in open(r'C:\Users\Downloads\out.data').read().split('\n'):
   cur.exceute("select domainname from dns where responsedata like '%%%s%%'"% ip)
   rs = cur.fetchone()
   print ip, 'No result' if not rs else rs[0]

[tim_spac_126]

import MySQLdb

conn=MySQLdb.connect(host="localhost",user="root",passwd="password",db="db");
cur = conn.cursor()
for ip in open(r'C:\Users\Downloads\out.data').read().split('\n'):
   cur.exceute("select domainname from dns where responsedata like '%%%s%%'"% ip)
   rs = cur.fetchone()
   print ip, 'No result' if not rs else rs[0]