mysql模块学习：python操作MySQL数据库

先看个简单的例子：import MySQLdbtry:conn=MySQLdb.connect(host='localhost',user='root',passwd='root',db='test',port=3306)cur=conn.cursor()cur.execute('select * from user')cur.close()

3h随然吧

619人浏览 · 2014-02-20 20:10:17

3h随然吧 · 2014-02-20 20:10:17 发布

先看个简单的例子：

import MySQLdb
 
try:
    conn=MySQLdb.connect(host='localhost',user='root',passwd='root',db='test',port=3306)
    cur=conn.cursor()
    cur.execute('select * from user')
    cur.close()
    conn.close()
except MySQLdb.Error,e:
     print "Mysql Error %d: %s" % (e.args[0], e.args[1])