试了一下python操作数据库,准备将前端传回来的用户名和密码写入表中
试了半天不会把变量加在在sql语句里面
网上搜索了一下,要用元组来传递多个参数
sql = "insert into userinfo values(%s,%s)"
cursor.execute(sql,(name,password))
补充拓展:python往mysql数据库中写入数据和更新插入数据
1. 连接mysql
import pymysql
db = pymysql.connect(host='localhost', user='root', password='123456', port=3306, db='spiders')
cursor = db.cursor()
sql = 'select * from students;'
cursor.execute(sql)
cursor.close()
db.close()
2. 多字段动态插入mysql数据库中
import pymysql
db = pymysql.connect(host='localhost',user='root', password='123456', port=3306, db='spiders')
data = {
'id': '20180606',
'name': 'Lily',
<