通过内部连接的组合插入

Question

如何制作此select语句的insert语句？

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

我需要插入到所有et=1中；

感谢

Answer 1

编辑1:

我认为这里有一个答案：在相同表名的Insert查询中使用select查询

为您：

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

观察文档：

插入。。。SELECT语法

文档示例：

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

Answer 2

尝试类似的东西

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

Answer 3

据我所知，您希望为title like '%11%' or title like '%12%' 更新et=1

对于

update user u inner join petrazafa.class_room  c on u.id=c.id set et=1  where title like '%11%' 
or title like '%12%'