mysql in查询传入数组

SELECT * FROM employees WHERE department IN ('Sales', 'Marketing');

import mysql.connector

# 连接到数据库
db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase"
)

cursor = db.cursor()

# 定义部门数组
departments = ['Sales', 'Marketing']

# 构建IN查询字符串
in_clause = ', '.join(map(lambda x: f"'{x}'", departments))

# 执行查询
query = f"SELECT * FROM employees WHERE department IN ({in_clause})"
cursor.execute(query)

# 获取结果
results = cursor.fetchall()

for row in results:
    print(row)

-- 创建临时表
CREATE TEMPORARY TABLE temp_departments (department VARCHAR(255));

-- 插入数据
INSERT INTO temp_departments (department) VALUES ('Sales'), ('Marketing');

-- 使用JOIN替代IN查询
SELECT e.* 
FROM employees e 
JOIN temp_departments td ON e.department = td.department;