/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 votes108 views2 answers
Mamp connect mysql terminal
SQL
3 votes91 views2 answers
Oracle synonym
SQL
12 votes117 views6 answers
How to install sqlite3 in python
SQL
0 vote103 views2 answers
Cascade syntax in sql
SQL
0 vote102 views1 answer
Check psql validity function
SQL
0 vote110 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
1 vote105 views1 answer
Join to find results not in another table
SQL
1 vote117 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
1 vote100 views2 answers
How to search date in sql query
SQL
-1 vote91 views1 answer
Ssms connect with connection string
SQL