python操作mysql之增删改查

【delete】

 1 import MySQLdb
 2 
 3 conn = MySQLdb.connect("192.168.100.150","u01","123123","08day5" )
 4 cur = conn.cursor()
 5 
 6 sql = "delete from wang where id = %s"
 7 params = (3)
 8 
 9 cur.execute(sql,params)
10 conn.commit()
11 
12 cur.execute(‘select * from wang‘)
13 print cur.fetchall()
14 
15 cur.close()
16 conn.close()

【updata】

import MySQLdb

conn = MySQLdb.connect("192.168.100.150","u01","123123","08day5" )
cur = conn.cursor()

sql = "update wang set name = %s where id = %s"
params = (‘chenying‘,2)

cur.execute(sql,params)
conn.commit()

cur.execute(‘select * from wang‘)
print cur.fetchall()

cur.close()
conn.close()

【select】

 1 import MySQLdb
 2 
 3 conn = MySQLdb.connect("192.168.100.150","u01","123123","08day5" )
 4 cur = conn.cursor()
 5 
 6 
 7 cur.execute(‘select * from wang‘)
 8 print cur.fetchall()
 9 
10 cur.close()
11 conn.close()

python操作mysql之增删改查

标签：mysqldb   命令   ldb   print   命令执行   color   upd   values   必须