python MySQLdb wont insert into db

Question

Hi I have an issue with inserting info to my db. It doesn't give off an error.The code is here.

import MySQLdb as m

def Room(room):
   db = m.connect("localhost","root","password","rooms")
   cur = db.cursor()
   cur.execute('INSERT INTO rooms (name) VALUES("%s");'% (room))
def getRoomDb():
   db = m.connect("localhost","root","password","rooms")
   cur = db.cursor()
   cur.execute("SELECT * FROM rooms;")
   result = cur.fetchall()
   return result

print getRoomDb()

after i run the Room("roomname") it outputs like it should but nothing actually gets put into the db

if i run the Room() as print Room("roomname") it outputs none — michael
– michael, Commented Jan 21, 2013 at 18:47

Community · Accepted Answer · 2017-05-23 12:27:05Z

2

You didn't call commit() for the transaction in which you executed the INSERT.

In Python, the default action is to roll back work, unless you explicitly commit.

See also:

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Jan 21, 2013 at 18:50

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

Collectives™ on Stack Overflow

python MySQLdb wont insert into db

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