Shulou(Shulou.com)06/01 Report--

#! / usr/bin/env python#-*-coding: utf-8-*-import MySQLdb# establish a connection conn = MySQLdb.connect (host='127.0.0.1',user='root',passwd='1qaz#EDC',db='test_db') cur = conn.cursor () # manipulate data sql = "update user set name=%s where id=7" # define sql statement Used to modify the name field params = ("zhongjw",) # to "zhongjw" cur.execute (sql,params) conn.commit () # submit request # close database connection cur.close () conn.close ()

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.