Update from select sqlite

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

Update sqlite

UPDATE table
SET column_1 = new_value_1,
    column_2 = new_value_2
WHERE
    search_condition 
ORDER column_or_expression
LIMIT row_count OFFSET offset;

Sqlite update where exists

UPDATE employees
SET hire_date = (SELECT departments.start_date
                 FROM departments
                 WHERE departments.department_id = employees.department_id
                 AND departments.department_name = 'HR')
WHERE EXISTS (SELECT *
              FROM departments
              WHERE departments.department_id = employees.department_id
              AND departments.department_name ='HR');

Source: techonthenet.com

Similar codes

1 vote129 views1 answer
Oracle rolling back
SQL
0 vote145 views2 answers
Sql server set default value equal to auto increment
SQL
10 votes135 views6 answers
Mysql delete duplicates
SQL
0 vote143 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
22 votes152 views3 answers
Year format in date mysql
SQL
13 votes163 views2 answers
Sqlite rename table
SQL
7 votes134 views3 answers
Sql update where id
SQL
-1 vote143 views1 answer
Partial search in sql
SQL
0 vote141 views1 answer
Search db for table name
SQL
2 votes129 views1 answer
Sql update alias
SQL