拉丁的传说
实际上,您可以通过以下两种方法之一:MySQL更新联接语法:UPDATE tableA aINNER JOIN tableB b ON a.name_a = b.name_bSET validation_check = if(start_dts > end_dts, 'VALID', '')-- where clause can go hereAnsi SQL语法:UPDATE tableA SET validation_check =
(SELECT if(start_DTS > end_DTS, 'VALID', '') AS validation_check FROM tableA INNER JOIN tableB ON name_A = name_B
WHERE id_A = tableA.id_A)选择对你来说最自然的哪一个。