python如何连接mysql
1、安装Python开发环境安装MySQL数据库安装Python连接MySQL的依赖包MySQLdb
2、编写代码文件python_connect_mysql.py
3、#! /usr/bin/env python#coding: utf8import MySQLdbif __name__ == "__main__": conn = None try: config = {"host":'127.0.0.1', "port":3306, "user":'test', "passwd":'12345678', "db":'test', "charset":'utf8'} conn = MySQLdb.connect(**config) conn.autocommit(True) cursor = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor) cursor.execute("select name,age from tbtest") rows = cursor.fetchall() for row in rows: print row["name"] print row["age"] except Exception, e: print str(e) finally: if conn: conn.close()
4、执行代码:pythonpython_connect_mysql.py
声明:本网站引用、摘录或转载内容仅供网站访问者交流或参考,不代表本站立场,如存在版权或非法内容,请联系站长删除,联系邮箱:site.kefu@qq.com。
阅读量:23
阅读量:52
阅读量:73
阅读量:59
阅读量:45