使用Python操作MySQL

比较简单,直接上代码了。

import MySQLdb

def showResult(res):
        for i in res:
                print i

conn=MySQLdb.connect(host="localhost",user="root",passwd="123456",db="cloud",charset="utf8")
cursor = conn.cursor()
cursor.execute('select * from filelist')
res = cursor.fetchall()
showResult(res)

 

posted @ 2014-12-10 20:16  KevinHwang  阅读(157)  评论(0编辑  收藏  举报