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, Jan 21 '13 at 18:47

score 2 · Accepted Answer · edited May 23 '17 at 12:27

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.

python MySQLdb wont insert into db

1 Answers1

Linked

Related