Update select mysql

Mysql update from select

UPDATE t1
SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
FROM MY_TABLE AS t1
INNER JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.ID
WHERE t1.COL3 = 'OK';

Set column in all row mysql

UPDATE name_table SET param = 'VALUE';

Update select mysql

UPDATE tableA a
INNER JOIN tableB b ON a.name_a = b.name_b
SET validation_check = if(start_dts > end_dts, 'VALID', '')
-- where clause can go here

Source: stackoverflow.com

Update Select Mysql

UPDATE
    `table1` AS `dest`,
    (
        SELECT
            *
        FROM
            `table2`
        WHERE
            `id` = x
    ) AS `src`
SET
    `dest`.`col1` = `src`.`col1`
WHERE
    `dest`.`id` = x
;

Source: stackoverflow.com

Similar codes

14 votes226 views4 answers
Remove record from table sql
SQL
17 votes219 views2 answers
Mysql date to string
SQL
31 votes226 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote219 views1 answer
How to between in sql
SQL
4 votes225 views1 answer
Mysql ip address data type
SQL
2 votes199 views1 answer
Mysql add boolean column
SQL
0 vote207 views1 answer
Oracle db get table sizes
SQL
4 votes213 views2 answers
Sql vs mysql
SQL
4 votes229 views1 answer
Search column by name mysql
SQL
0 vote208 views1 answer
How to convert DateTime to VarChar SQL
SQL