| 注册
请输入搜索内容

热门搜索

Java Linux MySQL PHP JavaScript Hibernate jQuery Nginx
wuxqing
8年前发布

使用Python获取Mysql数据

#!/usr/bin/python  # -*- coding: UTF-8 -*-    # pip install MySQL-python    import MySQLdb, os     try:      conn = MySQLdb.connect(host='172.17.42.1', user='数据库访问用户', passwd='数据库访问密码', db='数据库名', port=3306)        cur = conn.cursor()      cur.execute('SELECT `id`, `name`, `path`, FROM `doc_file`')        # 获取全部记录      results=cur.fetchall()      for r in results:          id, name, path = r[0], r[1], r[2]            if path and not os.path.exists(path):              print 'file not exist: ', id, name, path, flashpath        cur.close()      conn.close()  except MySQLdb.Error,e:       print "Mysql Error %d: %s" % (e.args[0], e.args[1])