Insert Faker data in MySQL database with Python 3.9.5

Question

I have very simple table: customers (id int auto_increment, name varchar(255), address varchar(255).

Want to insert fake data using npm faker with python.

Started Python yesterday and I`m lost. Help plz.

Tried many queries but does not work.

 for i in range (10):

   name = fake.name()

  address =fake.address()

  mycursor.executemany("INSERT INTO customers (name, address)\ VALUES ({},{})"

  db.commit()

You put format placeholders but does not substitute them with the values. — Akina, May 25 '21 at 09:59

score 0 · Answer 1 · answered May 25 '21 at 14:57

0

for i in range(10):

name=fake.name()

address=fake.street_address()

cur.execute('insert into customers(name,address) VALUES (%s,%s)', (name, address));

db.commit()

print('FINALLY')

answered May 25 '21 at 14:57

sndd

1
1

Insert Faker data in MySQL database with Python 3.9.5

1 Answers1