Need ability to prevew update or insert SQL

trurl123 posted 3 weeks ago in General

Some SQL editors allow to prevew SQL before to apply changes. I mean MySQL Workbench and DBeaver. Is it possible to implement it in HeidiSQL? I mean live data editing in the table editor. I need to change query before running because of replication restrictions.

ansgar posted 3 weeks ago

You mean you need to change each and every write-query? Ok, never heard that. What exactly would you modify?

trurl123 posted 3 weeks ago

I need to remove database name from query. E.g. "update db.users set name='aa' where id=1" replaced with "update users set name='aa' where id=1" If I don't then replication will be broken. May be this is a replication bug. I am only developer and I don't have an access to set up the server.

ansgar posted 3 weeks ago

Did you have a look at the bugtracker, if there is a similar request already?

trurl123 posted 3 weeks ago

I searched throw the issues and could not find anything like this.

ansgar posted 3 weeks ago

In that case, if you really like to request that, you should file a new issue there.

Please login to leave a reply, or register at first.