python操作mysql之增刪改查

標籤：mysqldb   命令   ldb   print   命令執行   color   upd   values   必須   

【insert】

 1 import MySQLdb 2  3 conn = MySQLdb.connect("192.168.100.150","u01","123123","08day5" ) 4 cur = conn.cursor() 5  6 #把資料放到元組 7 sql = "insert into wang (id,name) values(%s,%s)" 8 params = (3,‘wangsuchen‘) 9 10 cur.execute(sql,params) 11 conn.commit() #提交12 13 cur.execute(‘select * from wang‘)14 print cur.fetchall() #必須在上一條execute命令執行後再執行這條，15 16 cur.close()17 conn.close()

 

【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 MySQLdbconn = 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之增刪改查