>>> 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????
--
http://mail.python.org/mailman/listinfo/python-list
