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

[expired user #10430]'s profile image [expired user #10430] posted 7 years ago in General Permalink

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

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.