python之连接mysql
安装模块mysql-connector-python,下载地址:
http://download.youkuaiyun.com/detail/clean_water/9679100
源码如下:
------------------------------------------------
python之连接mysql
安装模块mysql-connector-python,下载地址:
http://download.youkuaiyun.com/detail/clean_water/9679100
源码如下:
------------------------------------------------
#!/usr/bin/env python
# -*- coding:utf-8 -*-
# 导入模块
import mysql.connector
def con_mysql():
try:
config = {
'user':'root',
'password':'root',
'host':'192.168.166.202',
'port':3306,
'database':'test'}
# 得到连接对象
conn = mysql.connector.connect(**config)
# 得到游标
cur = conn.cursor()
# 执行sql,可以是任何sql
cur.execute("SELECT * from student")
# 得到sql的执行结果
result_set = cur.fetchall()
# 关闭连接,一定要关闭连接
conn.close()
# 返回sql执行结果
return result_set
except Exception,e:
print "Mysql Error " ,e
# 调用方法,并打印结果
print con_mysql()
更多请关注:FlyTester,关注技术的测试者
QQ群:456850134
web站:www.flytester.org
微信扫描二维码关注: