python 执行sql语句
import pymysql
#导入模块
def sqlvalue():
#建立连接
conn = pymysql.connect(
host='test1267.db.58dns.org',
port=13312,
user='jinrong_rw',
password='0c414262412d5be1',
database='dbwww58com_consumeorder',
)
#创建游标,默认是元祖格式
cursor=conn.cursor(cursor=pymysql.cursors.DictCursor)
id="44076769926412"
sql1="update consume_order SET status=300 where wb_id='%s'"%id
sql2 = "update consume_order SET order_amount=100 where wb_id='%s'" %id
sql = "select order_amount,status from consume_order where wb_id='%s'" % id
cursor.execute(sql1)
conn.commit()
cursor.execute(sql2)
#增删改需要commit
conn.commit()
cursor.execute(sql)
#接收返回受影响的行数
r = cursor.fetchall()
print(r)
cursor.close() #关闭游标
conn.close() #关闭连接
sqlvalue()