/SQL/Insert and initialize a SQL column with value dependent on another column data

Insert and initialize a SQL column with value dependent on another column data

UPDATE table
SET col = new_value
WHERE col = old_value
AND other_col = some_other_value;

UPDATE table
SET col = new_value
WHERE col = old_value
OR other_col = some_other_value;

Source: chartio.com

Similar codes

0 vote333 views1 answer
Delete ids between sql
SQL
0 vote243 views1 answer
Sql gap missing values
SQL
1 vote255 views1 answer
Create temporal table in sql
SQL
0 vote219 views0 answer
How to connect to datbase in springboot
SQL
0 vote248 views1 answer
Python mysql query where
SQL
0 vote378 views1 answer
Sql insert exemplo
SQL
3 votes276 views1 answer
Postgres select max value
SQL
2 votes260 views2 answers
How to view created temporary tables in mysql
SQL
0 vote258 views1 answer
Porcentaje sql
SQL
0 vote261 views1 answer
How to order result of subquery in select
SQL