Python, Pymysql, Inserted rows do not apper in the database

Question

I have this program in Python:

import pymysql

conn = pymysql.connect(<stuff here>)
cur = conn.cursor()

cur.execute('''
    INSERT INTO aderenti (nome, comune, provincia)
    VALUES ('Mario', 'Spinea', 'VE');
    ''')

the code runs fine, and if I run the SQL command in MySQL workbench a new row appears with the selected values. But if I run this code in Python, no new row appears. How is this possible?

Thanks a lot, I will try it right now. Thogh I have previously added rows with Python without using conn.commit(), and it worked. So when do I have to use it and when I don't? — Nadni
– Nadni, Commented Dec 1, 2016 at 18:09

Invisible · Accepted Answer · 2017-05-30 18:11:27Z

2

You already got the answer. as a side note include

autocommit=True

in your connection. It's just easy to have in connection.

answered May 30, 2017 at 18:11

Invisible

6911 bronze badges

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

Collectives™ on Stack Overflow

Python, Pymysql, Inserted rows do not apper in the database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related