在表格中插入记录
在表格中插入记录详细操作教程
以下实例为学习在表格中插入记录,具体代码如下:
# Filename : example.py
# Author by : www.lidihuo.com
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="myusername",
passwd="mypassword",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("John", "Highway 21")
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record inserted.")
执行以上代码输出结果为:
# Filename : example.py
# Author by : www.lidihuo.com
1 record inserted.