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

#!/ usr/bin/env python# -*- coding: utf-8-*- import MySQLdb #establish connection conn = MySQLdb.connect(host ='127.0.0.1', user ='root ',passwd ='1qaz#EDC', db ='test_db') cur = conn.cursor() #operate on data sql = "delete from user where id=%s" #define a sql statement that deletes the specified ID params =('3') #Parameter ID is 3 cur.execute(sql,params) #execute sql statement 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.