CentOS Python操作MySQL的脚本简录

yum -y install MySQL-python

cat >/tmp/test.py<<EOF
#!/usr/bin/python
# coding:utf-8
# 连接MySQL测试
import MySQLdb
try:
    conn = MySQLdb.connect( host='127.0.0.1',
                            user='root',
                            passwd='vincent',
                            db='mysql',
                            port=3306,
                            charset='utf8')
    cur=conn.cursor()
    cur.execute('select Host,User from user')
    # 将指针置0，取出所有记录
    # cur.scroll(0,mode='absolute')
    results=cur.fetchall()
    print '-' * 23
    for r in results:
        print "| %-9s | %-7s |" % (r[0],r[1])
    print '-' * 23
    cur.close()
    conn.close()
except MySQLdb.Error,e:
    print "Mysql Error %d: %s" % (e.args[0], e.args[1])
EOF

python test.py

[TOC]