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.
我正在使用HeidiSQL 9.3.0.5104。如果我在使用表GUI时插入一个新行或更改一个值(通过单击一个字段并在其中输入)，然后在该行之外单击，那么HeidiSQl将自动运行该行的插入或更新，而不需要任何确认。如果您试图在一行中编辑多个字段，并且想要复制并粘贴其中的每个值，那么这将非常糟糕。
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.
我查看了Preferences菜单中的所有选项卡，但没有发现与此“特性”相关的任何内容。有什么方法可以禁止这种行为吗?也许在执行查询之前，您可以运行某种安全模式来验证查询?当我使用MySQL Workbench时，在它运行我使用GUI生成的查询之前，我必须单击“应用”按钮。我希望在HeidiSQL中有类似的功能。
1 个解决方案
#1
2
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.
- 要还原您的更改，您可以按红色“X”的“还原更改”按钮，或者按Esc。
- To apply changes, press the "Post changes" button on the main toolbar or just click outside the edited row.
- 要应用更改，请单击主工具栏上的“Post changes”按钮，或者单击已编辑的行之外。
There is no way of disabling this "Click outside to apply" behaviour.
无法禁用这种“在外部单击以应用”行为。
#1
2
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.
- 要还原您的更改，您可以按红色“X”的“还原更改”按钮，或者按Esc。
- To apply changes, press the "Post changes" button on the main toolbar or just click outside the edited row.
- 要应用更改，请单击主工具栏上的“Post changes”按钮，或者单击已编辑的行之外。
There is no way of disabling this "Click outside to apply" behaviour.
无法禁用这种“在外部单击以应用”行为。