学步园

本文地址：http://blog.csdn.net/kongxx/article/details/7094018

1. 要想使Python可以操作MySQL数据库，首先需要安装MySQL-python包，在CentOS上可以使用一下命令来安装

$ sudo yum install MySQL-python2. 啥都不说了，走两步吧，下面的程序创建了一个到mysql数据库的连接，然后执行了一个简单的查询，并打印查询结果

import MySQLdb</p> <p>conn = MySQLdb.connect (host = "172.17.23.121", user = "fkong", passwd = "fkong", db = "fkong")<br /> cursor = conn.cursor ()<br /> cursor.execute ("SELECT VERSION()")<br /> row = cursor.fetchone ()<br /> print "MySQL server version:", row[0]<br /> cursor.close ()<br /> conn.close ()3. 下面看一个数据库建表和插入操作
import MySQLdb</p> <p>conn = MySQLdb.connect (host = "172.17.23.121", user = "fkong", passwd = "fkong", db = "fkong")<br /> cursor = conn.cursor ()</p> <p>cursor.execute ("""<br /> CREATE TABLE TEST<br /> (<br /> ID INT,<br /> COL1 VARCHAR(40),<br /> COL2 VARCHAR(40),<br /> COL3 VARCHAR(40)<br /> )<br /> """)</p> <p>cursor.execute ("""<br /> INSERT INTO TEST (ID, COL1, COL2, COL3)<br /> VALUES<br /> (1, 'a', 'b', 'c'),<br /> (2, 'aa', 'bb', 'cc'),<br /> (3, 'aaa', 'bbb', 'ccc')<br /> """)</p> <p>conn.commit()<br /> cursor.close ()<br /> conn.close ()4. 下面再来看看查询，查询通常有两种方式：一种是使用cursor.fetchall（）获取所有查询结果，然后再一行一行的迭代；另一种每次通过cursor.fetchone()获取一条记录，直到获取的结果为空为止。看一下下面的例子：

import MySQLdb</p> <p>conn = MySQLdb.connect (host = "172.17.23.121", user = "fkong", passwd = "fkong", db = "fkong")<br /> cursor = conn.cursor ()</p> <p>cursor.execute ("SELECT * FROM TEST")<br /> rows = cursor.fetchall()<br /> for row in rows:<br /> print "%d, %s, %s, %s" % (row[0], row[1], row[2], row[3])</p> <p>print "Number of rows returned: %d" % cursor.rowcount</p> <p>cursor.execute ("SELECT * FROM TEST")<br /> while (True):<br /> row = cursor.fetchone()<br /> if row == None:<br /> break<br /> print "%d, %s, %s, %s" % (row[0], row[1], row[2], row[3])</p> <p>print "Number of rows returned: %d" % cursor.rowcount</p> <p>cursor.close ()<br /> conn.close ()