python mysql基本操作

標籤：

#連結mysql
#插入資料
import  MySQLdb

conn = MySQLdb.connect(host = ‘127.0.0.1‘,user = ‘root‘,passwd = ‘‘,db = ‘mytest‘)
cur = conn.cursor()
reConn =  cur.execute("insert into  userinfo(id,name) value(3,‘tony‘)")
conn.commit()
cur.close()
conn.close()

print reConn

#查詢資料
import  MySQLdb

conn = MySQLdb.connect(host = ‘127.0.0.1‘,user = ‘root‘,passwd = ‘‘,db = ‘mytest‘)
cur = conn.cursor(cursorclass=MySQLdb.cursors.DictCursor)   #以字典形式擷取資料
cur = conn.cursor()                                         #以元組形式擷取資料
#reConn =  cur.execute("select * from userinfo")
sql = "select name from userinfo where id = %s"
#sql = "select id from userinfo where id = %s"
params = 1
#params = ‘dendi‘
#reConn = cur.execute(sql,params)
reConn = cur.execute("select * from userinfo")
#fetchall把尋找到的資料一下拿出來
#fetchone逐個取資料
# data = cur.fetchall()
data = cur.fetchone()
print data
data = cur.fetchone()
print data
cur.close()
conn.close()
# print data
print reConn

#更新資料
import  MySQLdb

conn = MySQLdb.connect(host = ‘127.0.0.1‘,user = ‘root‘,passwd = ‘‘,db = ‘mytest‘)
cur = conn.cursor()
sql = "update userinfo set name = ‘aaa‘ where id = ‘%s‘"
params = 1
reConn =  cur.execute(sql,params)
conn.commit()
#conn.rollback()
cur.close()
conn.close()

print reConn

#刪除資料
import  MySQLdb

conn = MySQLdb.connect(host = ‘127.0.0.1‘,user = ‘root‘,passwd = ‘‘,db = ‘mytest‘)
cur = conn.cursor()
sql = "delete from userinfo  where id = ‘%s‘"
params = 1
reConn =  cur.execute(sql,params)
conn.commit()
#conn.rollback()
cur.close()
conn.close()

print reConn



參考部落格：http://www.cnblogs.com/wupeiqi/articles/4198124.html

python mysql基本操作