python连mysql

1 安装MySQLdb模块

sudo apt-get install mysqldb

2 代码

import MySQLdb  
  
conn = MySQLdb.connect(host='localhost', user='dbuser', passwd='dbpasswd',db='mysql')  
  
cursor = conn.cursor()  
  
count = cursor.execute('select host,user from user')  
  
print 'count %s ' % count  
   
print "only one:"  
result = cursor.fetchone();  
print result  
 
print 'host: %s   user: %s' % result   
  
print "only 5:"  
results = cursor.fetchmany(5)  
for r in results:  
    print r  
  
print "result set:"  
  
cursor.scroll(0,mode='absolute')  
results = cursor.fetchall()  
for r in results:  
    print r  
conn.close()