python mysql

#!/usr/bin/python
#-*- coding:utf-8 -*-

import MySQLdb as mdb

con=None

try:
   con=mdb.connect('localhost','root','123','test')
   cur=con.cursor()
   cur.execute("select version()")
   data=cur.fetchone()
   print data
finally:
   if con:
      con.close()

 

posted @ 2013-12-05 09:39  墨迹哥's  阅读(188)  评论(0编辑  收藏  举报