使用python生成随机数据然后插入到mysql中去
import mysql.connector
from faker import Faker
import tqdm
import random
from datetime import datetime, timedelta
connection = mysql.connector.connect(
host='localhost',
user='root',
password='123456',
database='cityTemperature'
)
cursor = connection.cursor()
faker = Faker()
insert_query = "INSERT INTO cityTemperature (city,temperature,date) VALUES (%s, %s, %s)"
for _ in tqdm.tqdm(range(1000000)):
city_name = faker.city()
random_date = datetime.now() - timedelta(days=random.randint(1, 365))
random_float = round(random.uniform(0, 50), 2)
data_to_insert = (city_name,random_float, random_date)
cursor.execute(insert_query, data_to_insert)
connection.commit()
cursor.close()
connection.close()