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 vote164 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
1 vote183 views1 answer
Sql first
SQL
8 votes169 views2 answers
Replace string value in sql
SQL
14 votes173 views5 answers
Set password for postgres user ubuntu
SQL
11 votes198 views3 answers
Change column name sql server management studio
SQL
1 vote168 views1 answer
What is a Database?
SQL
0 vote208 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote173 views1 answer
Query to get all primary keys and foreign key
SQL
0 vote164 views2 answers
Sql drop view if exists
SQL
0 vote167 views1 answer
Left join in codeigniter query builder
SQL