1, conn = MySQLdb.Connection('host', 'user','password', 'dbname') ,这是一种常用的链接方式
2,conn = MySQLdb.Connection('host', 'user','password') 这种方式链接时没有指定数据库,但他是可行的,当需要用数据库时可以这样做conn.select_db('dbname')
select_db()用来切换、选取你所要执行的数据
#coding:utf8
import MySQLdb
import sys
def truncate():
con=MySQLdb.connect(host='127.0.0.1',user='idexadmin',passwd='idex000',charset='utf8')
print "oks"
con.select_db("idexdb")
cur=con.cursor()
print cur
table=['pk_dtasklog','pk_duprds','pk_dcount','pk_ditem','pk_ditems','tag_swapcount','pk_iflgups','pk_udinfo','pk_udinfos','tag_rvcount','tag_rvlog']
for item in table:
cur.execute('select * from %s'%item)
print cur.fetchone()
con.select_db('test')
cur.close()
con.close()
if __name__=="__main__":
truncate()