Update sql
ps: 从数据库获取想要的信息,select sql
select * from table_a;
// 连表查询数据,join,取公共的部分
select * from table_a as ta
join table_b as tb
on ta.id = tb.task_id
where ta.task_status = 'DELETE_FAILED' and tb.email = 'tina@test.com';
更新一个联合表中的数据 update XXX set XXX
// option 1
update table_a as ta, table_b as tb
set ta.delete_flag = 1
where ta.id = tb.task_id and ta.task_status = 'DELETE_FAILED' and tb.email = 'tina@test.com';
// option 2
update table_a as ta
join table_b as tb
on ta.id = tb.task_id
set delete_flag = 0
where ta.task_status = 'DELETE_FAILED' and tb.email = 'tina@test.com';
// option 3
update table_a as ta
inner join (select table_b as tb where tb.email = 'tina@test.com') as tmp
on ta.id = tmp.task.id
set ta.frozen = 1
where ta.sd_config_id in (11, 12) and ta.delete_flag = 0;