mysql生成正态分布数据

import mysql.connector
import numpy as np

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

cursor = db.cursor()

# 生成正态分布数据
mean = 0
std_dev = 1
num_samples = 1000
data = np.random.normal(mean, std_dev, num_samples)

# 插入数据到MySQL表中
for value in data:
    sql = "INSERT INTO your_table (value_column) VALUES (%s)"
    cursor.execute(sql, (value,))

db.commit()
cursor.close()
db.close()

DELIMITER //

CREATE PROCEDURE GenerateNormalData()
BEGIN
  DECLARE i INT DEFAULT 1;
  DECLARE mean FLOAT DEFAULT 0;
  DECLARE std_dev FLOAT DEFAULT 1;
  DECLARE num_samples INT DEFAULT 1000;
  DECLARE random_value FLOAT;

  WHILE i <= num_samples DO
    SET random_value = RAND() * 2 - 1; -- 生成[-1, 1]之间的随机数
    SET random_value = mean + random_value * std_dev; -- 转换为正态分布
    INSERT INTO your_table (value_column) VALUES (random_value);
    SET i = i + 1;
  END WHILE;
END //

DELIMITER ;

CALL GenerateNormalData();