distal-attribute
distal-attribute
distal-attribute
distal-attribute

Is it possible to view the commit SQL running in background of Heidi?

1337h4x0R posted 2 months ago in General

Say I have a table with write permissions. I change the value of a specific element in a row in Heidi, then commit that change. What I see in the Heidi GUI is the value change from the original value to the new one, but in the background, Heidi is running an UPDATE statement. Is it possible to see the actual SQL statement being run that is being obfuscated by Heidi?

Thank you!

ansgar posted 2 months ago

There is nothing obfuscated by HeidiSQL. The original UPDATE query can be found in the SQL log panel.

If it's cut at 2000 characters or something, you probably need to increase the "Snip lines to ..." setting in Preferences > Logging.

And of course the UPDATE query may be hidden, if you disabled "Internal SQL queries" on the same preferences/logging tab.

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