python connection is not saving data in database

Question

I have connected to database in python successfully but it is not saving the data I provide.Here is the code :

    try:
    connection = MySQLdb.connect(host="localhost",user="root",passwd="",db="traffic_alert")
except Exception as e:
    print('Not connected')


   cursor = connection.cursor()
cursor.execute("insert into data (main_status,extracted_info,time) values (%s,%s,%s)",[sentence,final_result,time])
print(sentence)
print(final_result)
print(time)

it can successfully print sentence, final_result and time but not saving them in database.sentence,final_result and time are less than 50 characters.I have created the database manually in mysql with these rows :

id -> auto_increment,pk
main_status -> varchar(255)
extracted_info -> varchar(255)
seen  -> int(10),Null=True
time ->varchar(255)

I presume copy/paste or formatting error, but your opening try indentation is off. Also, any error messages either on python or db side perhaps? — Ondrej K.
– Ondrej K., Commented Jun 10, 2018 at 15:20
connection.commit() is the solution. Then it saved in database. — Yunus
– Yunus, Commented Jun 12, 2018 at 10:04

Yash Pokar · Accepted Answer · 2018-06-10 13:58:32Z

6

connection.commit()

After cursor.execute

answered Jun 10, 2018 at 13:58

Yash Pokar

5,5511 gold badge15 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

python connection is not saving data in database

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related