This is a discussion on mysql-query-browser newbie question within the MySQL Database forums, part of the Database Forums category; -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm using the gui tools mysql-query-browser, inserting into an innodb table. ...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1 I'm using the gui tools mysql-query-browser, inserting into an innodb table. Autocommit is turned off at the server level with "init_connect='SET AUTOCOMMIT=0'". Immediately after executing the insert, a select does *not* show the new row. If I do the same thing in the mysql command line tool, it shows the new row. What's going on? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) Comment: Using GnuPG with PCLinuxOS - http://enigmail.mozdev.org iEUEARECAAYFAkdqy1gACgkQCaxpabs7RHKg0gCgyjmYvGJGn6 WRvbEM2xLMMVWg /mIAmIyX2DS3z7ZD4XRodRVonjylyT4= =pHTt -----END PGP SIGNATURE----- |