Hello out there,
I wonder if there is a possibility to run a connection specific startup script in SQL Developer. (I'm currently on 23.1)
What I want to do is something like running
/*sqldev:stmt*/ start transaction
for MySQL connections. Yesterday I ran an update statement against a MySQL Database and did something wrong with the where condition. I ended up with 109,000 rows updated instead of only one and the update was autocommitted.
I know, I should use MySQL Workbench for that which supports transactions, but for some quick SQLs it's convenient to use SQL Developer for both Oracle and MySQL.
So, if I would be able to set up a startup script for MySQL connections, either starting a new transaction or setting the session to read only that would prevent such mistakes.
Even better would be native transaction support for MySQL in SQL Developer. ;-)