python操作数据库mysql
来源:互联网 发布:新闻联播图片素材软件 编辑:程序博客网 时间:2024/06/05 17:42
1. 要想使Python可以操作MySQL数据库,首先需要安装MySQL-python包,在CentOS上可以使用一下命令来安装
- $ sudo yum install MySQL-python
- import MySQLdb
- conn = MySQLdb.connect (host = "172.17.23.121", user = "fkong", passwd = "fkong", db = "fkong")
- cursor = conn.cursor ()
- cursor.execute ("SELECT VERSION()")
- row = cursor.fetchone ()
- print "MySQL server version:", row[0]
- cursor.close ()
- conn.close ()
- import MySQLdb
- conn = MySQLdb.connect (host = "172.17.23.121", user = "fkong", passwd = "fkong", db = "fkong")
- cursor = conn.cursor ()
- cursor.execute ("""
- CREATE TABLE TEST
- (
- ID INT,
- COL1 VARCHAR(40),
- COL2 VARCHAR(40),
- COL3 VARCHAR(40)
- )
- """)
- cursor.execute ("""
- INSERT INTO TEST (ID, COL1, COL2, COL3)
- VALUES
- (1, 'a', 'b', 'c'),
- (2, 'aa', 'bb', 'cc'),
- (3, 'aaa', 'bbb', 'ccc')
- """)
- conn.commit()
- cursor.close ()
- conn.close ()
- import MySQLdb
- conn = MySQLdb.connect (host = "172.17.23.121", user = "fkong", passwd = "fkong", db = "fkong")
- cursor = conn.cursor ()
- cursor.execute ("SELECT * FROM TEST")
- rows = cursor.fetchall()
- for row in rows:
- print "%d, %s, %s, %s" % (row[0], row[1], row[2], row[3])
- print "Number of rows returned: %d" % cursor.rowcount
- cursor.execute ("SELECT * FROM TEST")
- while (True):
- row = cursor.fetchone()
- if row == None:
- break
- print "%d, %s, %s, %s" % (row[0], row[1], row[2], row[3])
- print "Number of rows returned: %d" % cursor.rowcount
- cursor.close ()
- conn.close ()
0 0
- Python操作Mysql数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python操作MySQL数据库
- python 操作mysql 数据库
- python操作mysql数据库
- python 操作 mysql数据库
- python操作MySQL数据库
- python操作MySQL数据库
- Python操作MySQL数据库
- Python操作mysql数据库
- python操作MySQL数据库
- 封装android http框架
- Java设计模式(九)单例模式
- Maven 的生命周期介绍
- 关于Windows中生成FFTW的lib文件时报LNK1104错误
- cocos creator Button控件用法
- python操作数据库mysql
- ubuntu14.04 安装cuda8.0
- swift -基础1
- C/C++混合编程--extern “C” 使用方法详解
- Android UI设计之RecyclerView
- Coursera Machine Learning Week 3 - Programming Exercise 2: Logistic Regression
- 手机root后adb命令安装应用到system目录冒充系统app的cmd脚本
- ruby 语法(ARGV,传参数)--读取文件档案
- 深入理解Apache Mina (1)---- Mina的几个类