SQL insert statement is not inserting values in database from Jupyter notebook( Anaconda)

Question

I have some problem inserting data in MySQL. The program is running without any errors but the values are not getting inserted. Below is the code. I doubt there is some mistake in format specifiers.The python version I am using is 3.5.3. Thanks in advance.

#!/usr/bin/python 

import MySQLdb 

# Open database connection 
db = MySQLdb.connect("localhost","root","pwd","project") 

# prepare a cursor object using cursor() method 
cursor = db.cursor() 

add_metric = ("INSERT INTO metrics "  "(clicks, pageviews, sessions, source, browser,device_type)"
               "VALUES (%s, %s, %s, %s, %s,%s)")

data_metric = (5,6,7,'s','a','f')

cursor.execute(add_metric, data_metric)

cursor.close();

db.close();

Stefan Stift · Accepted Answer · 2017-05-09 06:16:32Z

2

I would say that you have to commit your connection or set autoCommit to true

db.autocommit(True);

or

db.commit(); before closing the cursor

answered May 9, 2017 at 6:16

Stefan Stift

361 bronze badge

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

Collectives™ on Stack Overflow

SQL insert statement is not inserting values in database from Jupyter notebook( Anaconda)

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