yiii2 将原生执行的sql结果,当作where查询条件的方法
时间: 2024-03-27 08:39:32 浏览: 13
您可以使用子查询将原生执行的SQL结果作为WHERE查询条件。例如,假设您执行了以下SQL语句:
```
SELECT id FROM users WHERE age > 30;
```
您可以将其转换为子查询,如下所示:
```
SELECT * FROM orders WHERE user_id IN (SELECT id FROM users WHERE age > 30);
```
这将返回在“users”表中年龄大于30岁的用户的ID,然后在“orders”表中查找这些用户的订单。请注意,这只是一个示例,您需要根据您的具体需求进行调整。
相关问题
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.cskt.mapper.SupplierMapper.getAllSupplier
出现"org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.cskt.mapper.SupplierMapper.getAllSupplier"的错误是因为在MyBatis-Plus持久化框架中,Mapper.java与Mapper.xml之间的绑定关系失败导致的。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* *3* [org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.xxx.xxx 的解决...](https://blog.csdn.net/Hello_World_QWP/article/details/126713075)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 100%"]
[ .reference_list ]