python更新mysql数据

>>>cur.execute("update users set username=%s where id=2",("mypython"))

>>>cur.execute("select * from users where id=2")

>>>cur.fetchone()

>>>conn.commit()

>>>cur.close()

>>>conn.close()

 

posted @ 2018-10-29 00:00  香蕉都驼背  阅读(3869)  评论(0编辑  收藏  举报