pip install faker
python
from faker import Faker
python
fake = Faker("zh_CN")
python
name = fake.name()
address = fake.address()
phone_number = fake.phone_number()
python
import MySQLdb
conn = MySQLdb.connect(host="localhost", user="root", passwd="password", db="test")
cursor = conn.cursor()
name = fake.name()
address = fake.address()
sql = "INSERT INTO users(name, address) VALUES (%s, %s)"
params = (name, address)
cursor.execute(sql, params)
conn.commit()
cursor.close()
conn.close()
