Python & MySQL problem with input to table..!

[hiroc13]

>>import MySQLdb

>>db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", db = "base1")
c = db.cursor ()
c.execute(""" INSERT INTO table1 (prvo, drugo) VALUES ('test', '1') """)
c.execute("SELECT * FROM table1")
res = c.fetchall ()
print res

When I start this code I get ((15L, 'test', 1L),) on the screen but if
I first execute this:

>>import MySQLdb
db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", db = "base1")
c = db.cursor ()
c.execute(""" INSERT INTO table1 (prvo, drugo) VALUES ('test', '1') """)

..... this write to table1
and now this:

>>Import MySQLdb
db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", db = "base1")
c = db.cursor ()
c.execute("SELECT * FROM table1")
res = c.fetchall ()
print res

I get only this: "()" - the table1 is empty ... I write 10 times same
thing to table... only PRIMARY KEY is change

WHY????

[Justin Ezequiel]

On Jun 29, 4:26 pm, hiroc13 <[e-mail]:

>import MySQLdb
db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", db = "base1")
c = db.cursor ()
c.execute(""" INSERT INTO table1 (prvo, drugo) VALUES ('test', '1') """)
c.execute("SELECT * FROM table1")
res = c.fetchall ()
print res

When I start this code I get ((15L, 'test', 1L),) on the screen but if
I first execute this:

>import MySQLdb
db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", db = "base1")
c = db.cursor ()
c.execute(""" INSERT INTO table1 (prvo, drugo) VALUES ('test', '1') """)

.... this write to table1
and now this:

>Import MySQLdb
db = MySQLdb.connect (host = "localhost", user = "root", passwd = "pass", db = "base1")
c = db.cursor ()
c.execute("SELECT * FROM table1")
res = c.fetchall ()
print res

I get only this: "()" - the table1 is empty ... I write 10 times same
thing to table... only PRIMARY KEY is change

WHY????

try a `db.commit()` after the INSERT

[hiroc13]

Thanks!!!! It is working!