Dec-29-2019, 08:32 AM
Hi...I want to insert the new data if it is not exist in MySQL. This is the code:
---------------------------------------
id q polarity senti
---------------------------------------
1 ('good') 0.4404 positive
**Hope you can help me as I am a new learner. Thank you
mySql_insert_query = """INSERT INTO sent (q,polarity,senti) SELECT * FROM (SELECT %s,%s,%s) AS tmp WHERE NOT EXISTS (SELECT q FROM sent WHERE q = q) LIMIT 1; """ records_to_insert = [(str(row),float(sentiment_dict['compound']), str(sentiment))] cursor = connection.cursor() cursor.executemany(mySql_insert_query, records_to_insert) connection.commit()The output that I got is shown below. It can only insert 1 data only, which is ('good'), while ('very bad') cannot insert in the database:
Output:('good',)
1 Record inserted successfully into table
('very bad',)
0 Record inserted successfully into table
This is my table in MySQL:---------------------------------------
id q polarity senti
---------------------------------------
1 ('good') 0.4404 positive
**Hope you can help me as I am a new learner. Thank you