mysql_hanyu.py

python_MySQL之间的几个小例子。对于python连接的数据库

#!/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)