MySQL 入库操作通常指的是将数据插入到 MySQL 数据库的表中。这是数据库管理中最基本的操作之一,用于存储和管理数据。
以下是使用 Python 和 MySQL Connector 进行入库操作的示例代码:
import mysql.connector
# 连接到 MySQL 数据库
mydb = mysql.connector.connect(
host="localhost",
user="yourusername",
password="yourpassword",
database="yourdatabase"
)
# 创建游标对象
mycursor = mydb.cursor()
# 单条插入示例
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = ("John", "Highway 21")
mycursor.execute(sql, val)
# 多条插入示例
sql = "INSERT INTO customers (name, address) VALUES (%s, %s)"
val = [
("Peter", "Lowstreet 4"),
("Amy", "Apple st 652"),
("Hannah", "Mountain 21"),
("Michael", "Valley 345"),
("Sandy", "Ocean blvd 2"),
("Betty", "Green Grass 1"),
("Richard", "Sky st 331"),
("Susan", "One way 98"),
("Vicky", "Yellow Garden 2"),
("Ben", "Park Lane 38"),
("William", "Central st 954"),
("Chuck", "Main Road 989"),
("Viola", "Sideway 1633")
]
mycursor.executemany(sql, val)
# 提交事务
mydb.commit()
print(mycursor.rowcount, "条记录已插入。")
INSERT IGNORE
或 ON DUPLICATE KEY UPDATE
语句处理冲突。通过以上方法,您可以有效地进行 MySQL 入库操作,并解决可能遇到的问题。