DB Parser

import MySQLdb

db = MySQLdb.connect(db='', user='root', passwd='', host='localhost', charset='euckr', use_unicode=True) // 한글깨짐 해결

cursor = db.cursor()

cursor.execute('SELECT * FROM table')

recs = cursor.fetchall()

f = open("auth.log", 'w')

for rec in recs:

    result = '[no] = %d\n'%(rec[0])

    f.write(result.encode("utf-8"))

     

f.close()

cursor.close()