python操作mysql，增，删，改，查

import MySQLdb

conn = MySQLdb.connect(host='192.168.1.21',user='yangqw',passwd='1',db='free')
cur = conn.cursor()

# sql = 'insert into student(name,age) values(%s,%s)'
# params = ('alex',21)
# reCount = cur.execute(sql,params)
# conn.commit()  # 增，改，删，都要commit，查，不需要

# sql1 = 'select * from student'
# reCount1 = cur.execute(sql1)
# data = cur.fetchall()
# print data

sql2='delete from student where id_1= %s'
params2=(1)
reCount2 = cur.execute(sql2,params2)
conn.commit()

sql1 = 'select * from student'
reCount1 = cur.execute(sql1)
data = cur.fetchall()
print data

# print reCount1
cur.close()
conn.close()

=========================

# 一次批量插入多条

import MySQLdb

conn = MySQLdb.connect(host='192.168.1.21',user='yangqw',passwd='1',db='free')
cur = conn.cursor()

li =[
('alex',22),
('sb',33),
]
reCount = cur.executemany('insert into student(name,age) values(%s,%s)',li)

conn.commit()
cur.close()
conn.close()

print reCount

=========================

带列名

cur = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)

转载于:https://www.cnblogs.com/yycc/p/7302667.html