Search code examples
mysqldatabaseheidisql

How to disable automatic update/insert in HeidiSQL when row loses focus


I am using HeidiSQL 9.3.0.5104. If I insert a new row or change a value when using the table GUI (by clicking in a field and typing in it) and then I click outside of that row, HeidiSQl automatically runs an INSERT or UPDATE for that row without any confirmation. This is especially terrible if you are trying to edit multiple fields in a row and you want to copy and paste each of those values in.

I have looked through all the tabs in the Preferences menu but haven't found anything relating to this "feature". Is there a way to disable this behavior? Maybe there's some sort of safe mode you can run that verifies a query before it executes? When I used MySQL Workbench I had to click an "Apply" button before it ran my queries that were generated from using the GUI. I'd love for there to be a similar feature in HeidiSQL.


Solution

  • Edited - or better said: changed values are displayed with a red triangle in the upper left corner.

    • To revert your changes, you can either press the "Revert changes" button with the red "X", or press Esc.
    • To apply changes, press the "Post changes" button on the main toolbar or just click outside the edited row.

    There is no way of disabling this "Click outside to apply" behaviour.