1. 首页
  2. SQL

Postgres仅更新一列

代码示例

8
0

N

UPDATE table_name
SET column1 = value1,
    column2 = value2,
    ...
WHERE condition;
5
0

N

UPDATE table
SET column1 = value1,
    column2 = value2 ,...
WHERE
	condition;
0
0

N

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

类似页面

带有示例的类似页面

其他语言

此页面有其他语言版本

Русский
..................................................................................................................
Ссылка
English
..................................................................................................................
Link
Italiano
..................................................................................................................
Link
Polski
..................................................................................................................
Link
Română
..................................................................................................................
Legătură
한국어
..................................................................................................................
링크
हिन्दी
..................................................................................................................
लिंक
Français
..................................................................................................................
Lien
Türk
..................................................................................................................
Atıf
Česk
..................................................................................................................
Odka
Português
..................................................................................................................
Referênci
ไทย
..................................................................................................................
เชื่อมโยง
Español
..................................................................................................................
Referencia
Slovenský
..................................................................................................................
Odkaz
Балгарскі
..................................................................................................................
Спасылка
Íslensk
..................................................................................................................
Link

受欢迎的此类别

标籤的相关热门网页

源码插入与蟒蛇
postgressql更新
如何更新的数据在postgresl
如何编辑数据的一个原因表
如何更新列值在postgres
postgres结果从更新sql statement
postgres更新所有列
蟒蛇insert into table源码
更新的价值列在postgres
我怎么插入数据表使用源码蟒蛇
更新列在postgres
updatein postgresql
sqlite3插入数据表蟒蛇
更新数据sql postgresql
修改行在postgresql
插入目的在源码表蟒蛇