MYSQL data insert query doesn't work in Python

Question

This is my insert query.

rule_result = max(item_counts.iteritems(), key=operator.itemgetter(1))[0]

# DB connection
conn = MySQLdb.connect(host="localhost",user="root",passwd="",db="chat_app",use_unicode=True,charset="utf8")
x = conn.cursor()

cursor.execute('''INSERT into rule_based_results (emotion) values (%s)''',(rule_result))
conn.commit()
conn.close()

There isn't any error. But this query doesn't work. Can anyone tell me what is the problem with my query.

What exactly doesn't work?

ILostMySpoon
– ILostMySpoon

2017-06-15 16:18:03 +00:00
Commented Jun 15, 2017 at 16:18 — ILostMySpoon
– ILostMySpoon, Commented Jun 15, 2017 at 16:18
Data not insert to the Database.

Chathuri Fernando
– Chathuri Fernando

2017-06-15 16:18:58 +00:00
Commented Jun 15, 2017 at 16:18 — Chathuri Fernando
– Chathuri Fernando, Commented Jun 15, 2017 at 16:18

ILostMySpoon · Accepted Answer · 2017-06-15 16:27:56Z

1

You initialized x to your connection's cursor object but never used it.

x.execute('''INSERT into rule_based_results (emotion) values (%s)''',(rule_result))
conn.commit()
x.close()
conn.close()

answered Jun 15, 2017 at 16:27

ILostMySpoon

2,3992 gold badges21 silver badges26 bronze badges

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

1 Comment

Chathuri Fernando Over a year ago

Thank you I made my mistake.

Collectives™ on Stack Overflow

MYSQL data insert query doesn't work in Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related