UPDATE query based on SELECT Query

update tableA a
left join tableB b on a.name_a = b.name_b
set validation_check = if(start_dts > end_dts, 'VALID', '')
-- where clause can go here

1

2

3

4

update tableA a

left join tableB b on a.name_a = b.name_b

set validation_check = if(start_dts > end_dts, 'VALID', '')

-- where clause can go here

update tableA set validation_check = 
    (SELECT if(start_DTS > end_DTS,'VALID','') as validation_check
        FROM tableA
        LEFT JOIN tableB ON name_A = name_B
        WHERE id_A = tableA.id_A)

1

2

3

4

5

update tableA set validation_check =

(SELECT if(start_DTS > end_DTS,'VALID','') as validation_check

FROM tableA

LEFT JOIN tableB ON name_A = name_B

WHERE id_A = tableA.id_A)

UPDATE [table_name] AS T1,
      (SELECT [column_name] 
        FROM [table_name] 
        WHERE [column_name] = [value]) AS T2 
  SET T1.[column_name]=T2.[column_name] + 1
WHERE T1.[column_name] = [value];

1

2

3

4

5

6

UPDATE [table_name] AS T1,

(SELECT [column_name]

FROM [table_name]

WHERE [column_name] = [value]) AS T2

SET T1.[column_name]=T2.[column_name] + 1

WHERE T1.[column_name] = [value];

Related posts