您现在的位置是： 首页 > 后端开发 > 编程开发
DataGrip 防止全表更新或删除限制
2024-04-13 【后端开发】
简介Unsafe query: 'Update' statement updates all table rows at once because 'where' condition is always true
在DataGrip软件种，有一个很好用的功能，可以在执行 update/delete 语句时，忘写 where 语句或者写了where但是依然会导致全表更新/删除的情况下进行提示
Unsafe query: 'Update' statement updates all table rows at once because 'where' condition is always true
如果依然想要执行当前SQL，可以点击 Execute 继续执行。但是当不小心点到 Execute and Suppress 之后，这个提示就不会再有了，老版本的会有一个下面这样的选项卡，可以再加上限制提示
"Data editor safety precautions"（数据编辑器安全预防措施）的选项
但是新版本的，提示设置的位置修改了，这里做个记录，以备不时之需。位置在如下图所示的位置。
Database -> Query Execution -> Show warning before running potentially unsafe queries （数据库->查询执行->运行可能不安全的查询前显示警告）
很赞哦！ (0)
相关文章
- DataGrip 防止全表更新或删除限制
- idea 提示 @Transactional self-invocation (in effect, a method within the target object calling another method of the target object) does not lead to an actual transaction at runtime 问题原因
- IntelliJ IDEA 2023.1 发布，新UI 改进
- The bean 'xxxx.FeignClient' could not be registered. A bean with that name has already been defined and overriding is disabled. 问题原因
- Syntax Error: `asyncRouterMap` has already been exported. Exported identifiers must be unique. 错误原因
- MySQL 备份操作
- 控制台出现 was not registered for synchronization because DataSource is not transactional 是什么问题
- curl Empty reply from server 原因及解决方案
- Java BigDecimal 加减乘除计算示例
- docker容器里面没有vim解决方案
点击排行
- DataGrip 防止全表更新或删除限制
- idea 提示 @Transactional self-invocation (in effect, a method within the target object calling another method of the target object) does not lead to an actual transaction at runtime 问题原因
- IntelliJ IDEA 2023.1 发布，新UI 改进
- The bean 'xxxx.FeignClient' could not be registered. A bean with that name has already been defined and overriding is disabled. 问题原因
- Syntax Error: `asyncRouterMap` has already been exported. Exported identifiers must be unique. 错误原因
- MySQL 备份操作
- 控制台出现 was not registered for synchronization because DataSource is not transactional 是什么问题
- curl Empty reply from server 原因及解决方案
- Java BigDecimal 加减乘除计算示例
- docker容器里面没有vim解决方案
猜你喜欢
- DataGrip 防止全表更新或删除限制
- idea 提示 @Transactional self-invocation (in effect, a method within the target object calling another method of the target object) does not lead to an actual transaction at runtime 问题原因
- IntelliJ IDEA 2023.1 发布，新UI 改进
- The bean 'xxxx.FeignClient' could not be registered. A bean with that name has already been defined and overriding is disabled. 问题原因
- Syntax Error: `asyncRouterMap` has already been exported. Exported identifiers must be unique. 错误原因
- MySQL 备份操作
- 控制台出现 was not registered for synchronization because DataSource is not transactional 是什么问题
- curl Empty reply from server 原因及解决方案
- Java BigDecimal 加减乘除计算示例
- docker容器里面没有vim解决方案
