python 操作MySQL详解

#!/usr/bin/env python
#coding=utf-8


import MySQLdb
import time
date = time=time.strftime('%Y%m%d',time.localtime(time.time()))
file = open("/etc/passwd")
line = file.readline()
conn = MySQLdb.connect(host='192.168.188.44',user='anjuke',passwd='anjuke',db='test')
curs = conn.cursor()
#curs.execute("create table passwd ( user varchar(100))")
while line:
    value = [line]
    curs.execute("insert into passwd values(%s)",value)
    print "ok" , value
    line=file.readline().strip()
conn.commit()
curs.close()
file.close()