Insert into mysql a python list

Question

I tried many times to solve my problem with other questions in stackoverflow with no success. I'm learning python right now.

I know how to do it in PHP but I need to do it in python.

I have a table dentistas with 4 columns id, web, email, telefono.

And I import from another file with a list containing web urls.

I want to insert those websurls in the web column.

The code that im using right now doesn't shows me an error in the terminal, but doesn't insert anything to the table:

# coding=utf-8
import MySQLdb
from parser import lista

bd = MySQLdb.connect('localhost', 'testuser', 'test123', 'leads') # Connecting to the database
cursor = bd.cursor()         # Creating the cursor 

for x in lista:
    cursor.execute("INSERT INTO dentistas(web) VALUES(%s)", (x,))

dot.Py · Accepted Answer · 2017-04-04 11:50:37Z

2

You forgot to commit() and save your current database state.

Try using bd.commit() after the loop.

edited Apr 4, 2017 at 11:50

answered Apr 4, 2017 at 11:45

dot.Py

5,1775 gold badges35 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Pablo Barrios Over a year ago

Thanks, was the commit() ;)

dot.Py Over a year ago

forgot the previous answer.... have you comitted after making the changes in your database?

dtell Over a year ago

100% turnaround haha but you are right! See this stackoverflow.com/questions/2847999/… question why you have to commit cursor executions that change your database.

Pablo Barrios Over a year ago

Yes, was the commit()

Collectives™ on Stack Overflow

Insert into mysql a python list

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related