每天学一个sql - 【update】更新数据库里的一个字段

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;