in einer Tabelle will ich mit SQL direkt vorhandene Datensätze auswählen und als neue anfügen, wobei einzelne Felder der neuen Datensätze geändert werden sollen.
Code: Alles auswählen
INSERT INTO "Time" ("ID", "Day", "days", "hours", "end", "timestamp", "lastChanged", "bText", "dezimal4", "statusID", "minutes")
SELECT "ID",
CASE "Day"
WHEN '2022-05-02 13:05:00' THEN '2023-05-11 10:20:00'
WHEN '2022-05-02 18:02:00' THEN '2023-05-11 13:10:00'
WHEN '2022-05-10 10:10:00' THEN '2023-05-14 13:35:00'
WHEN '2022-05-10 11:09:00' THEN '2023-05-14 16:20:00'
ELSE "Day"
END AS "Day", "days", "hours", "end", "timestamp", "lastChanged", "bText", "dezimal4", "statusID", "minutes"
FROM "Time"
WHERE "Day" IN ('2022-05-02 13:05:00', '2022-05-02 18:02:00', '2022-05-10 10:10:00', '2022-05-10 11:09:00')
Code: Alles auswählen
1: firebird_sdbc error:
*violation of PRIMARY or UNIQUE KEY constraint "INTEG_25" on table "Time"
*Problematic key value is ("ID" = 552)
caused by
[Wiederholung der SQL Anweisung]
Grüße
Malt
Version: 7.5.1.2 (X86_64) / LibreOffice Community
Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL threaded