faker生成数据插入mysql

from faker import Faker
import pymysql
# 表名
table_name = 'test_panyq11'
# 数据条数
table_row = 20
# 数据库连接信息
db = pymysql.connect(host='10.20.30.40', port=3306, user='qwer', passwd='pwd', db='qwer', charset='utf8')

cursor = db.cursor()
# 建表
cursor.execute("DROP TABLE IF EXISTS %s"%table_name)
sql = """CREATE TABLE %s (username char(20),name char(20),sex char(2),address char(20),mail char(20),birthdate char(20))"""%table_name
cursor.execute(sql)
​​​​​​​# 生成用户数据
fake = Faker("zh-CN")
for i in range(table_row):
    user = fake.simple_profile()
    keys = ','.join(user.keys())
    values = "'" + "','".join(list(map(str, user.values()))) + "'"
    sql = "insert into di_test.{}({}) values({})".format(table_name, keys, values)
    print(sql)
    cursor.execute(sql)
db.commit()
db.close()