Inserting into a database table not working with Python

Question

I am inserting into a table using the following code:

## Connection established ##

sql = """ INSERT INTO Singer ( name ) VALUES( %s ) """

params = ('Rihanna',)

cursor.execute(sql, params)

cursor.fetchall()  ## Result - into no result set 
cursor.description ## Result - Nonetype

I am not able to understand where am I going wrong?

Thanks

ByteFlowr · Accepted Answer · 2019-10-26 14:57:05Z

2

You have to commit your change.

cursor = conn.cursor()
sql = """ INSERT INTO Singer ( name ) VALUES( %s ) """

params = ('Rihanna',)

cursor.execute(sql, params)
conn.commit() # Important, apply changes to database!
cursor.fetchall()  ## Result - into no result set 
cursor.description ## Result - Nonetype

answered Oct 26, 2019 at 14:57

ByteFlowr

5007 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Inserting into a database table not working with Python

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