python 操作 mysql,pythonmysql,查询(两种方法):```
python 操作 mysql,pythonmysql,查询(两种方法):```
查询(两种方法):```pythonimport MySQLdb
conn = MySQLdb.connect (host = "localhost", user = "root", passwd = "root", db = "fish")
cursor = conn.cursor ()
cursor.execute ("SELECT * FROM polls_poll")rows = cursor.fetchall() #获取所有结果集for row in rows: #从结果集中一条一条读出来 print "%d, %s, %s" % (row[0], row[1], row[2])
print "Number of rows returned: %d" % cursor.rowcount
cursor.execute ("SELECT * FROM polls_poll")
while (True):
row = cursor.fetchone() #从结果集的开始,获取一条记录, 移动一下游标,直到结束返回None if row == None:
break
print "%d, %s, %s" % (row[0], row[1], row[2])
print "Number of rows returned: %d" % cursor.rowcount
cursor.close ()
conn.close ()
插入: ```pythoncursor.execute ("INSERT INTO two(name, age) VALUES ('bill', 18)") #返回受影响的行数,执行错误返回异常
更新:
cursor.execute ("UPDATE two SET name = 'jack', age = '22' WHERE name = 'bill'") #返回受影响的行数,执行错误返回异常
相关内容
- 透明LCD时钟,lcd时钟,# -*- coding
- python中os模块的常用方法,pythonos模块,os是python用于操
- 将天气情况设置为桌面壁纸,天气情况桌面壁纸,#!/us
- 双鱼图,,#!/usr/bin/e
- Macbook pro + pycharm 不能导入包,macbookpycharm,新入手了ma
- python定时器爬取豆瓣音乐Top榜歌名,python定时器,作者
- Python创建Windows 服务,python创建windows,Python 写wind
- urllib2下载文件,,#!/usr/bin/p
- 画折线图的程序,画折线图程序,#_*_coding:u
- python 去除html标签的代码,python去除html标签,#! /usr/bin
评论关闭