supic

from faker import Faker
import pymysql

mydb = pymysql.connect(
    host = "localhost",
    user = "root",
    passwd = "inbarcaitrust10",
    db = "novica"
)

fake = Faker()
db = "INSERT INTO users1(email,created_at) VALUES(%s,%s)"
values = [
    fake.email(),
    fake.date()
    ]

mycursor = mydb.cursor()

for x in range(500):
    mycursor.execute(db,values)

mydb.commit()