mysql批量加逗号

SELECT GROUP_CONCAT(name SEPARATOR ',') AS names
FROM users;

import mysql.connector

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

cursor = db.cursor()

# 查询所有用户的名字
cursor.execute("SELECT name FROM users")

# 获取查询结果
names = cursor.fetchall()

# 将名字用逗号分隔并拼接成一个字符串
names_str = ','.join([name[0] for name in names])

print(names_str)

# 关闭连接
cursor.close()
db.close()

SET GLOBAL group_concat_max_len = 1000000;

db = mysql.connector.connect(
    host="localhost",
    user="yourusername",
    password="yourpassword",
    database="yourdatabase",
    charset='utf8mb4'
)