/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

2 votes253 views1 answer
Sql count having
SQL
2 votes236 views2 answers
Function in sql
SQL
0 vote265 views1 answer
Test sql query
SQL
0 vote247 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote207 views1 answer
Connection error in mysql workbench
SQL
0 vote250 views1 answer
Oracle call a function in a insert statement
SQL
0 vote280 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote368 views1 answer
Postgresql powershell query
SQL
5 votes238 views1 answer
List foreign key oracle
SQL
3 votes254 views4 answers
Mysql decimal
SQL

Share