在mysql中在表2的s1为023，表1的s2与表2的s2相同的表1的s3改为a

Question

在表2的s1为023的情况下，表2的s2与表1的s2相同的情况下把表1的s3改成a，表1的s2与表2的s2相关联

UPDATE skt1 s1 inner join skt3 s3

on s1.skf4 = s3.skf31
SET s1.skf3 = 'a'
WHERE s1.skf4 = (SELECT skf31 FROM skt3 WHERE skf30 ='023');

UPDATE skt1 s1 inner join skt3 s3

on s1.skf4 = s3.skf31
SET s1.skf3 = 'a'
WHERE s1.skf4 = (SELECT skf31 FROM skt3 WHERE skf30 ='023')

Affected rows: 0
时间: 0s

Answer 1

改成这样

UPDATE skt1 s1 inner join skt3 s3
on s1.skf4 = s3.skf31
SET s1.skf3 = 'a'
WHERE s3.skf30  = '023';