Error Updating Mysql database via python

Question

I am trying to add all words of a text file into a column such that one row has one word. my code is as :

 import MySQLdb
 conn = MySQLdb.connect (host = "localhost",user = "root", db = "pcorpora")
 c = conn.cursor()
 file = open('C:\Users\Admin\Desktop\english.txt', 'r')
 words = list(file.read())
 i=0
 for value in words:
    c.execute("""INSERT INTO tenglish (`english words`) VALUES (%s)""" % (words[i]) i=i+1)`

The code run without error but table is still empty.

Adem Öztaş · Accepted Answer · 2014-11-20 15:53:34Z

1

You should use commit

c.execute("""INSERT INTO tenglish (`english words`) VALUES (%s)""" % (value))
con.commit()

This method sends a COMMIT statement to the MySQL server, committing the current transaction. Since by default Connector/Python does not autocommit, it is important to call this method after every transaction that modifies data for tables that use transactional storage engines.

edited Nov 20, 2014 at 15:53

answered Nov 20, 2014 at 15:30

Adem Öztaş

21.6k5 gold badges36 silver badges42 bronze badges

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

3 Comments

Shristi Baral Over a year ago

I again get error it says: Traceback (most recent call last): File "<pyshell#10>", line 1, in <module> c.execute('query') File "C:\Python27\lib\site-packages\MySQLdb\cursors.py", line 202, in execute self.errorhandler(self, exc, value) File "C:\Python27\lib\site-packages\MySQLdb\connections.py", line 36, in defaulterrorhandler raise errorclass, errorvalue ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'query' at line 1")

Shristi Baral Over a year ago

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'query' at line 1"

Adem Öztaş Over a year ago

What does i=i+1 mean?

Collectives™ on Stack Overflow

Error Updating Mysql database via python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related