[EMAIL PROTECTED] wrote:
> hello,
> i have problem manipulating mySQL data. When i add values in a Table,
> i can recieve them instantly but when i check the table from another
> script, the new values dont exist.
>
> i'm not experienced in sql dbses so the problem might be something
> outside python.
>
> example (i do this to add values, and then i check and values have
> been added):
>
> ####################################################################
> import MySQLdb
> conn = MySQLdb.connect (host = 'localhost',
> user = 'root',
> passwd = 'MYPASHERE',
> db = 'test')
> cursor = conn.cursor ()
>
> cursor.execute ("""
> INSERT INTO testsignin (user, pass, secretcode)
> VALUES
> ('dkiauser', 'dkiapass', 'dkiacode'),
> ('gmtuser', 'gmtpass', 'gmtcode')
> """)
>
> print "Number of rows inserted: %d" % cursor.rowcount
>
> cursor.execute ('SELECT * FROM testsignin WHERE user="gmtuser"')
> row = cursor.fetchone()
> print row
> ####################################################################
>
> but then when i try to get them from another script with this:
>
> ####################################################################
> import MySQLdb
> conn = MySQLdb.connect (host = 'localhost',
> user = 'root',
> passwd = 'MYPASHERE',
> db = 'test')
> cursor = conn.cursor ()
>
> cursor.execute ('SELECT * FROM testsignin WHERE user="gmtuser"')
> row = cursor.fetchone()
> print row
> ####################################################################
>
> i get a None
You need to commit your changes, using
conn.commit()
after doing them.
Diez
--
http://mail.python.org/mailman/listinfo/python-list
