help with mysql bindings

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Python section within the Software Development category of DaniWeb, a massive community of 427,377 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,038 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Python advertiser: Programming Forums

Thread Tools Display Modes

Views: 352 | Replies: 0

•

Join Date: Aug 2007

Posts: 128

Reputation: hacker9801 is on a distinguished road

Rep Power: 2

Solved Threads: 13

hacker9801 hacker9801 is offline

Offline

Junior Poster

help with mysql bindings

Feb 16th, 2008

I'm using MySQLdb.

Alright, I'm doing

 Help with Code Tags 
 python Syntax (Toggle Plain Text) 
import MySQLdb as mysql
db = mysql.connect("localhost", "root", "password", "database")
cu = db.cursor()
 
rows = cu.execute("INSERT INTO users (user, pass) VALUES ('test', 'test')")
print "rows affected:", rows
 
cu.close();db.close()
import MySQLdb as mysql
db = mysql.connect("localhost", "root", "password", "database")
cu = db.cursor()

rows = cu.execute("INSERT INTO users (user, pass) VALUES ('test', 'test')")
print "rows affected:", rows

cu.close();db.close()

Well, what happens is, it gets executed and prints "rows affected: 1" BUT when I check in my MySQL console no rows are there.

What's the problem? My SQL query is fine, and it works when I do it on the MySQL command line.

EDIT: okay, it works if I add a

 Help with Code Tags 
 python Syntax (Toggle Plain Text) 
db.commit()
db.commit()

. -.-
How can I make it auto-commit? I don't feel like doing that after every query, and my app is always using the same cursor for a long period of time

Last edited by hacker9801 : Feb 16th, 2008 at 1:08 am.