/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

2 votes331 views1 answer
Mysql select random id from table
SQL
2 votes302 views1 answer
Mysql admin u root p password change password
SQL
23 votes324 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
-1 vote396 views4 answers
Full outer join in sql
SQL
0 vote349 views1 answer
In mysql workbench contnent not feching
SQL
0 vote352 views1 answer
Oracle current timestamp
SQL
3 votes541 views6 answers
Sql unique select
SQL
1 vote328 views1 answer
Increase date by one day in sql oracle
SQL
18 votes297 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote285 views1 answer
Ms sql - add one hour to time
SQL