Python couldn't insert row to MySQL

Question

I'm trying to accomplish following query:

sql = "INSERT INTO adr_citydistricts (CityDistrict, CityDistrictRU) VALUES (% (ua) s,% (ru) s);"
data = {'ua': 'ukrainian', 'ru': 'russian'}
cursor.execute (sql, data)

After executing this query, there is no such record in table.

If do the same query in SQLyog, record will exists.

I've also tried:

sql = "INSERT INTO adr_citydistricts (CityDistrict, CityDistrictRU) VALUES ('123 ', '333');"
cursor.execute (sql)
print sql

and there is no row in the table.

The console displays : INSERT INTO adr_citydistricts (CityDistrict, CityDistrictRU) VALUES ('123 ', '333');

Executing this query in SQLyog, normally inserts a row in the table.

I've created another table with the same structure.

Can someone help me, please?

'osuschastvlyaetsya' - hah. Is it translated word from google? For finish sql transaction, you need to commit it. — Anton Barycheuski
– Anton Barycheuski, Commented Jan 25, 2014 at 9:47
@AntonBarycheuski in case you understand what that word mean, would you mind editing the question and translating it in English? Thanks. — Stefano Sanfilippo
– Stefano Sanfilippo, Commented Jan 25, 2014 at 9:55
@StefanoSanfilippo, Ok. I have correct it and rephrase some items. — Anton Barycheuski
– Anton Barycheuski, Commented Jan 26, 2014 at 11:43

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

You need to cursor.commit() to reflect changes.

9.2.3. Method MySQLConnection.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 Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Jan 25, 2014 at 9:46

Grijesh Chauhan

58.6k20 gold badges145 silver badges214 bronze badges

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

1 Comment

maxlen Over a year ago

db = MySQLdb.connect(host="localhost",user="root", passwd="*****", db="test", charset='utf8') cursor = db.cursor() sql = "INSERT INTO adr_citydistricts (CityDistrict, CityDistrictRU) VALUES ('123', '333');" cursor.execute(sql) db.commit()

Collectives™ on Stack Overflow

Python couldn't insert row to MySQL

1 Answer 1

9.2.3. Method `MySQLConnection.commit()`

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