/SQL/Postgres update single column

Postgres update single column

Postgres update column with value from another table

UPDATE t1 
set "Column" = t2.column
from t2 
where t2.id = t1."Id";

3

Postgres update single column

UPDATE table_name 
SET column_one = TRUE,
WHERE column_two = 'some string'

1

Similar codes

1 vote250 views1 answer
MySQL AND Operator
SQL
0 vote278 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
3 votes270 views1 answer
Sql replace character in string in all records
SQL
9 votes522 views2 answers
Current date in postgresql minus 1 day
SQL
1 vote269 views1 answer
Select 2 rows in sql
SQL
0 vote269 views1 answer
Restore backupfile discourse
SQL
0 vote287 views1 answer
Shortcut run sql pgadmin
SQL
1 vote280 views1 answer
Mysql show database size in mb
SQL
15 votes407 views2 answers
Sql order by alphabetical
SQL
3 votes294 views1 answer
Postgres count distinct
SQL

Share