Postgres aktualizace

Příklady kódu

N

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

N

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

N

update t1
        set t1.current_location =   
        CASE  
			WHEN SUBQUERY.status = 0 THEN 'Deployed' 
			WHEN SUBQUERY.status = 1 THEN 'Retrieved' 
			WHEN SUBQUERY.status = 2 THEN 'Lost' 
            ELSE t1.current_location
		END 
from (
    select t3.serial_number, t2.status
    from t2 inner join t3
        on t2.some_id = t3.some_id
    ) as SUBQUERY

where SUBQUERY.serial_number = t1.serial_number;

N


 UPDATE table_name

 SET column1 = value1, column2 = value2, ...

 WHERE condition;

Související stránky

Související stránky s příklady

V jiných jazycích

Tato stránka je v jiných jazycích

empty row

Русский

..................................................................................................................

Ссылка

English

..................................................................................................................

Link

Italiano

..................................................................................................................

Link

Polski

..................................................................................................................

Link

Română

..................................................................................................................

Legătură

한국어

..................................................................................................................

링크

हिन्दी

..................................................................................................................

लिंक

Français

..................................................................................................................

Lien

Türk

..................................................................................................................

Atıf

Português

..................................................................................................................

Referênci

ไทย

..................................................................................................................

เชื่อมโยง

中文

..................................................................................................................

链接

Español

..................................................................................................................

Referencia

Slovenský

..................................................................................................................

Odkaz

Балгарскі

..................................................................................................................

Спасылка

Íslensk

..................................................................................................................

Link

Populární v této kategorii

Oblíbené stránky s příklady v kategorii

empty row

jak vložit záznamy do tabulky z sqlite python

aktualizace psql příkaz

jak aktualizovat tabulku v pgadmin

sqlite python-li vložit do tabulky

nastavit sloupec vaklue v postgres

python-li vložit sqllite

aktualizace z postgres

python sqlite vložit hodnoty

python sqlite-li vložit celé číslo

postgres aktualizovat řádek, bez kolon

formu vložte do databáze sqlite python

jak aktualizovat všechny záznamy v tabulce v psql

jak upravit řádek s postgres

vložit sqlitequery python

postgres aktualizovat id z nové

vložit sqlite dotazu python