通过内部联接的组合插入 [英] insert into with combination of inner join

问题描述

我如何在这个select语句中插入一条语句?

How can I make an insert statement of this select statement?

SELECT et 
 FROM user 
      inner join  petrazafa.class_room 
      using(id) 
where title like '%11%' 
   or  title like '%12%';

我需要插入所有 et = 1;

I need to insert into all et = 1;

谢谢

推荐答案

我认为这里有一个答案:使用在插入查询中选择相同表名的查询

I think there's an answer here : Use select query inside the Insert query for the same table name

为您服务:

INSERT INTO `yourtable`(et)
SELECT et 
FROM user 
      inner join  petrazafa.class_room 
      using(id) 
 where title like '%11%' 
      or  title like '%12%';

观看文档:

插入...选择语法

文档示例:

INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

这篇关于通过内部联接的组合插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！