如何利用socket和mysql发送多个值到数据库中存储

import socket
import mysql.connector

s = socket.socket(socket.AF_INET, socket.SOCK_STREAM)
host = '127.0.0.1'  # MySQL数据库所在的IP地址
port = 8888  # 自定义的端口号
s.bind((host, port))

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

mycursor = mydb.cursor()

s.listen(5)
while True:
    clientsocket, address = s.accept()
    print(f"Connection from {address} has been established!")
    data = clientsocket.recv(1024).decode()  # 接收客户端发送的数据
    values = data.split(',')  # 将接收到的数据按照逗号分隔成多个值
    sql = "INSERT INTO yourtable (column1, column2, column3) VALUES (%s, %s, %s)"  # 根据表结构编写插入语句
    mycursor.execute(sql, values)  # 执行SQL语句，将值插入数据库
    mydb.commit()  # 提交事务
    clientsocket.close()  # 关闭客户端连接