如果需要根据表b的ids列找出表a对应的name:
select name from a where find_in_set (id ,(select ids from b where fid = 1...至4 |
| 1002 | 连续2次 从5至6 |
| 1001 | 连续2次 从7至8 |
| 1002 | 连续1次 从9至9 |
+------+----------------+
4 rows...ID下全部项目是否标记已完成,如果是,则update xyz表对应的列”全部完成“为”是“
update xyz inner join (select max(if(状态='已完成',0,1)) as...178, 212, 312, 412 );
create table t2(
id int
);
insert into t2 values
(1),
(1),
(2),
(4),
(5);
我想要对该表进行信息的统计...second" ),
(789,22222, "second" ),
(890,22222, "second" ),
(456,22222, "first" );
我想要对该表进行信息的统计