Need ability to prevew update or insert SQL

[expired user #11908]'s profile image [expired user #11908] posted 5 years ago in General Permalink

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's profile image ansgar posted 5 years ago Permalink

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

[expired user #11908]'s profile image [expired user #11908] posted 5 years ago Permalink

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's profile image ansgar posted 5 years ago Permalink

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

[expired user #11908]'s profile image [expired user #11908] posted 5 years ago Permalink

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

ansgar's profile image ansgar posted 5 years ago Permalink

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.