下午好，我正在嘗試在 PgAdmin 中運行查詢以增加表中的值（如果存在），如果不存在，它將創建行，但是我收到錯誤
ERROR: syntax error at or near "CASE"
LINE 1: CASE
^
SQL state: 42601
Character: 1
CASE
WHEN EXISTS(SELECT * FROM counter WHERE user_id = '321') THEN
UPDATE counter
SET counter = counter 1
WHERE user_id = '321'
ELSE
INSERT INTO counter (user_id) VALUES ('321') -- `counter` column is `SMALLINT DEFAULT 0`
END
我也嘗試過使用 upsert
INSERT INTO cookies_counter (user_id) VALUES ('321')
ON CONFLICT (user_id) DO
UPDATE SET counter = counter 1
WHERE user_id = '321'
它給了我一個不同的錯誤
ERROR: column reference "counter" is ambiguous
LINE 2: ON CONFLICT (user_id) DO UPDATE SET counter = counter 1
^
SQL state: 42702
Character: 100
uj5u.com熱心網友回復：
像這樣的東西可能會起作用，但這有點取決于表結構：
CREATE TABLE counter(user_id INT UNIQUE, counter smallint default 0);
INSERT INTO counter (user_id)
VALUES ('321')
ON CONFLICT (user_id)
DO UPDATE
SET counter = counter.counter 1::SMALLINT;
轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/444780.html
標籤：sql PostgreSQL 上插