PythonmysqlcodetoinsertdictionarycontaininganArray”（将包含数组的字典插入MySQL中的Python代码）

1. 使用Python的MySQL Connector模块连接到MySQL数据库：

import mysql.connector
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)
mycursor = mydb.cursor()

2. 定义一个字典，其中包含数组：

my_dict = {
  "name": "John",
  "age": 30,
  "hobbies": ["reading", "traveling", "music"]
}

3. 创建INSERT语句并使用execute()方法将字典插入MySQL表中：

sql = "INSERT INTO customers (name, age, hobbies) VALUES (%s, %s, %s)"
val = (my_dict["name"], my_dict["age"], str(my_dict["hobbies"]))
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record inserted.")

注意：由于MySQL无法将Python列表插入BLOB列中，因此需要将列表转换为字符串后再插入到MySQL表中。在查询数据时，我们可以通过eval()函数将字符串转换回Python列表。

完整代码示例：

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="mydatabase"
)

mycursor = mydb.cursor()

my_dict = {
  "name": "John",
  "age": 30,
  "hobbies": ["reading", "traveling", "music"]
}

sql = "INSERT INTO customers (name, age, hobbies) VALUES (%s, %s, %s)"
val = (my_dict["name"], my_dict["age"], str(my_dict["hobbies"]))
mycursor.execute(sql, val)

mydb.commit()

print(mycursor.rowcount, "record(s) inserted.")

输出：

1 record(s) inserted.