www.pudn.com > Vocabulary_python_mySQL.rar > MySQL_Hanyu.py

#!/usr/bin/python 
import MySQLdb  
#导入python2.4-mysqldb模块，以提供操作mysql的接口  
db_user = "root"  
db_pw = "myDBpass"  
conn = MySQLdb.connect("localhost", db_user, db_pw ,"xpower")  
cursor = conn.cursor() 
#cursor.scroll(0) 
 
#cursor.execute("""insert into xhanyu (cihui) values("妈妈")""") 
#conn.commit() 
#conn.commit() 
cursor.execute("""select * from xHanyu""") 
for id,cihui,priority in cursor.fetchall(): 
    print "%d %s %s" % (id,cihui,priority)