yum install MySQL-python -y conn = MySQLdb.Connect(host='localhost', user='root', passwd='root', db='python',charset='utf8') charset是要跟你数据库的编码一样,如果是数据库是gb2312 ,则写charset='gb2312'。 然后,这个连接对象也提供了对事务操作的支持,标准的方法 commit() 提交 rollback() 回滚 cursor用来执行命令的方法: callproc(self, procname, args):用来执行存储过程,接收的参数为存储过程名和参数列表,返回值为受影响的行数 execute(self, query, args):执行单条sql语句,接收的参数为sql语句本身和使用的参数列表,返回值为受影响的行数 executemany(self, query, args):执行单挑sql语句,但是重复执行参数列表里的参数,返回值为受影响的行数 nextset(self):移动到下一个结果集 cursor用来接收返回值的方法: fetchall(self):接收全部的返回结果行. fetchmany(self, size=None):接收size条返回结果行.如果size的值大于返回的结果行的数量,则会返回cursor.arraysize条数据. fetchone(self):返回一条结果行. scroll(self, value, mode='relative'):移动指针到某一行.如果mode='relative',则表示从当前所在行移动value条,如果 mode='absolute',则表示从结果集的第一行移动value条. import MySQLdb try: conn=MySQLdb.connect(host='127.0.0.1',user='root',passwd='admin',db='mysql',port=3306) cur=conn.cursor() #cur.execute('select * from user') cur.execute('select version()') data = cur.fetchone() print "Databases version: %s " % data cur.close() conn.close() except MySQLdb.Error,e: print "Mysql Error %d: %s" % (e.args[0], e.args[1]) import MySQLdb as mdb import sys conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) with conn: cur = conn.cursor() cur.execute("Create TABLE IF NOT EXISTS \ Writers(Id INT PRIMARY KEY AUTO_INCREMENT,NAME VARCHAR(25))") cur.execute("INSERT INTO Writers(Name) VALUES('Jack Luo')") cur.execute("INSERT INTO Writers(Name) VALUES('Kity Alice')") cur.execute("INSERT INTO Writers(Name) VALUES('Alex ok')") import MySQLdb as mdb import sys conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) with conn: cur = conn.cursor() cur.execute("SELECT * from Writers") rows = cur.fetchall() for row in rows: print row import MySQLdb as mdb import sys conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) with conn: cur = conn.cursor() cur.execute("SELECT * from Writers") numrows = int(cur.rowcount) for i in range(numrows): row = cur.fetchone() print row[0],row[1] #### import MySQLdb as mdb import sys conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) with conn: cur = conn.cursor(mdb.cursors.DictCursor) cur.execute("SELECT * FROM Writers") rows = cur.fetchall() for row in rows: print "%s %s" % (row["Id"],row["NAME"]) import MySQLdb as mdb import sys conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) with conn: cur = conn.cursor() cur.execute("SELECT * from Writers") rows = cur.fetchall() desc = cur.description print 'cur.description:',desc print "%s %3s" % (desc[0][0],desc[1][0]) for row in rows: print "%2s %3s" % row import MySQLdb as mdb import sys conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) with conn: cur = conn.cursor() cur.execute("UPDATE Writers SET NAME=%s WHERE Id = %s",("Guy de Maupasant","4")) print "Number of rows updated: %d" % cur.rowcount import MySQLdb as mdb import sys try: fin = open("logo.png") img = fin.read() fin.close() except IOError,e: print "Error %d: %s" % (e.args[0],e.args[1]) sys.exit(1) try: conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) cursor = conn.cursor() cursor.execute("INSERT INTO Images SET Data='%s'" % mdb.escape_string(img)) conn.commit() cursor.close() conn.close() except mdb.Error,e: print "Error %d:%s" % (e.args[0],e.args[1]) sys.exit(1) ### import MySQLdb as mdb import sys try: conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) cursor = conn.cursor() cursor.execute("SELECT Data FROM Images LIMIT 1") fout = open('logo2.png','wb') fout.write(cursor.fetchone()[0]) fout.close() cursor.close() conn.close() except IOError,e: print "Error %d: %s" %(e.args[0],e.args[1]) sys.exit(1) #### import MySQLdb as mdb import sys try: conn = mdb.connect(host='127.0.0.1',user='root',passwd='admin',db='game',port=3306) cursor = conn.cursor() cursor.execte("UPDATE Writers SET Name = %s WHERE Id = %s",("JACK LUO","1")) cursor.execte("UPDATE Writers Set Name = %s where Id = %s ",("Alex LI",'2')) cursor.execte("UPDATE Writers Set Name = %s where Id = %s",("Leonid Leonov",'3')) conn.commit() cursor.close() conn.close() except mdb.Error,e: conn.rollback() print "Error %d: %s" % (e.args[0],e.args[1])
相关推荐
python-2.7.5-89.el7.x86_64.rpm python-devel-2.7.5-89.el7.x86_64.rpm python-iniparse-0.4-9.el7.noarch.rpm python-libs-2.7.5-89.el7.x86_64.rpm python-pycurl-7.19.0-19.el7.x86_64.rpm python-urlgrabber-...
ambari-2.7.4.0-centos7.tar.gz,HDP-3.1.4.0-centos7-rpm.tar.gz,HDP-UTILS-1.1.0.22-centos7.tar.gz,HDP-GPL-2.6.5.0-centos7-gpl.tar.gz
CentOS 7 安装 MySQL
centos7环境下离线安装python-devel需要的rpm文件,网站上下载最新的python-devel版本编译安装失败,从centos7的镜像里拷贝出来的低版本的rpm,测试安装成功。
cloudera-CDH5.16.1安装包,cloudera-manager-centos7-cm5.16.1_x86_64.tar.gz。cloudera-CDH5.16.1安装包,cloudera-manager-centos7-cm5.16.1_x86_64.tar.gz。
Ansible-python-vagrant-centos7.zip,在Python3.6上开发的一个Vagrant Box,有许多用于Django 2.x开发的附加功能。,ansible是一个简单而强大的自动化引擎。它用于帮助配置管理、应用程序部署和任务自动化。
HDP-GPL-3.1.4.0-centos7-gpl.tar.gz
emqttd emq emqx mqtt老版本 解压至centos7 64位系统,安装文档进行安装 emqttd-centos7-v2.3.11.zip
HDP-GPL-2.6.4.0-centos7-rpm.tar.gz
openGauss_3.0.0 企业版(openGauss-3.0.0-CentOS-64bit-all.tar.gz)适用于centos_x86_64
pgdg-centos96-9.6-3.noarch postgresql的依赖包postgresql的依赖包
2-CentOS6安装MySQL5.71
离线安装包,亲测可用
linux-centos7-mysql-5.7.36-linux-glibc2,数据库,集群数据库
离线安装python3.6.5--centos7.6.1810, tar -zxvf python3.6.5.tar.gz解压后直接执行./pyinstall.sh即可。中间需要选择一次y确认安装
离线安装amabri-2.7.4,之 HDP-UTILS-1.1.0.22-centos7.tar.gz
离线安装包,亲测可用
cdh 大数据软件 支持centos7 cdh 大数据软件 支持centos7 cdh 大数据软件 支持centos7 cdh 大数据软件 支持centos7
abrt-addon-python-2.0.8-6.el6.centos.i686.rpm是centos依赖包。
zabbix5安装文档-centos7.8-mysql5.7-nginx;zabbix5安装文档-centos7.8-mysql5.7-nginx